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 for Me (Login required).

Search for additional results

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