SAP Knowledge Base Article - Preview

2942253 - Large size of memory is occupied by allocators Pool/ColumnStore* or Pool/AttributeEngine-IndexVecto*

Symptom

  • You used script "HANA_Memory_Overview_<release>.txt" and "HANA_Memory_TopConsumers_<release>.txt" from SAP Note1969700 to check the memory usage status.
  • You notice that below allocators occupy most of total memory usage:
    Pool/AttributeEngine
    Pool/AttributeEngine/idattribute
    Pool/AttributeEngine-IndexVector-BlockIndex
    Pool/AttributeEngine-IndexVector-BTreeIndex
    Pool/AttributeEngine-IndexVector-Single
    Pool/AttributeEngine-IndexVector-SingleIndex
    Pool/AttributeEngine-IndexVector-Sp-Cluster
    Pool/AttributeEngine-IndexVector-Sp-Indirect
    Pool/AttributeEngine-IndexVector-Sp-Prefix
    Pool/AttributeEngine-IndexVector-Sp-Rle
    Pool/AttributeEngine-IndexVector-Sp-Sparse
    Pool/ColumnStore/Main/Dictionary/RoDict
    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/PageableBlock
    Pool/ColumnStoreTables/Main/Index/PageableSingle
    Pool/ColumnStoreTables/Main/Index/Single
    Pool/ColumnStoreTables/Main/PagedUncompressed
    Pool/ColumnStoreTables/Main/Rowid
    Pool/ColumnStoreTables/Main/Text/DocObjects
    Pool/ColumnStoreTables/Main/Uncompressed
    Pool/NameIdMapping/RoDict


            


Read more...

Environment

SAP HANA, platform edition

Product

SAP HANA, platform edition all versions

Keywords

OOM, high memory, dump, column store, heap memory, Pool/ColumnStore/Main/Dictionary/RoDict , KBA , HAN-DB-ENG , SAP HANA DB Engines , HAN-DB-MON , SAP HANA Monitoring , 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.