SAP Knowledge Base Article - Preview

3095946 - How to find large column store tables in system

Symptom

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."


Read more...

Environment

  • HANA database 1.0
  • HANA database 2.0

Keywords

HANA high memory consumption; column store tables; allocator allocator;  , KBA , HAN-DB , SAP HANA Database , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.