3095946 - How to find large column store tables in system

When checking used memory of system, one or some of below allocators appear on the top.  According to 1999997, these allocators are responsible for parts of the main storage in column store. Their memory allocation will implicitly reduce if you reduce the amount of table data in column store (archiving, cleanup, reduction of indexes, ...).  Therefore, you want to find large column store tables in system.

Pool/ColumnStore/Main/Compressed/Cluster
Pool/ColumnStore/Main/Compressed/Indirect
Pool/ColumnStore/Main/Compressed/Prefix
Pool/ColumnStore/Main/Compressed/Rle
Pool/ColumnStore/Main/Compressed/Sparse
Pool/ColumnStore/Main/Dictionary/RoDict
Pool/ColumnStore/Main/Dictionary/ValueDict
Pool/ColumnStore/Main/Index/Block
Pool/ColumnStore/Main/Index/PageableSingle
Pool/ColumnStore/Main/Index/Single
Pool/ColumnStore/Main/PagedUncompressed
Pool/ColumnStore/Main/Rowid
Pool/ColumnStore/Main/Text/DocObjects
Pool/ColumnStore/Main/Uncompressed
Pool/ColumnStoreTables/Main/Compressed/Cluster
Pool/ColumnStoreTables/Main/Compressed/Indirect
Pool/ColumnStoreTables/Main/Compressed/Prefix
Pool/ColumnStoreTables/Main/Compressed/Rle
Pool/ColumnStoreTables/Main/Compressed/Sparse
Pool/ColumnStoreTables/Main/Dictionary/RoDict
Pool/ColumnStoreTables/Main/Dictionary/ValueDict
Pool/ColumnStoreTables/Main/Index/Block
Pool/ColumnStoreTables/Main/Index/Single
Pool/ColumnStoreTables/Main/PagedUncompressed
Pool/ColumnStoreTables/Main/Rowid
Pool/ColumnStoreTables/Main/Text/DocObjects
Pool/ColumnStoreTables/Main/Uncompressed

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

• SAP HANA database 1.0 
• SAP HANA database 2.0 

HANA high memory consumption, column store tables, allocator allocator, Information about shrink, ShrinkCaller , KBA , HAN-DB , SAP HANA Database , How To