SAP Knowledge Base Article - Preview

2962223 - Pool/RowEngine/QueryExecution/SearchAlloc or Pool/RowEngine/QueryExecution high memory allocation

Symptom

  • There is a high memory usage value on the allocators:
    • "Pool/RowEngine/QueryExecution/SearchAlloc"

or

    • "Pool/RowEngine/QueryExecution".
  • The high value can be reported in a Memory Overview script output (HANA_Memory_Overview_* script from SQLStatements in SAP note 1969700) or can appear in an indexserver trace.

e.g.

HANA heap memory (used);      100;      100 (sfgdfd);       60 (Pool/RowEngine/QueryExecution/SearchAlloc)


Read more...

Environment

  • SAP HANA platform edition 1.0
  • SAP HANA platform edition 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

SAP HANA, memory, heap, allocator, OOM, out of memory, row engine, results, large , KBA , HAN-DB , SAP HANA Database , Problem

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.