SAP Knowledge Base Article - Preview

3463922 - Pool/RowEngine/QueryExecution/SearchAlloc: Troubleshooting Increasing Heap Memory Allocation

Symptom

  • It has been observed that the memory allocation for Pool/RowEngine/QueryExecution/SearchAlloc heap is continuously increasing.
  • The result of SQL Statement "HANA_Memory_ContextMemory" (1969700) (CATEGORY='%Pool/RowEngine/QueryExecution/SearchAlloc' , DB_USER='%', AGGREGATE_BY='CONN_ID, DB_USER')  shows that USED_GB are high for some connections.
    Example result:

      HOSTPORT CATEGORY                                  CATEGORY_CLASSNUM_ENTRIESCONN_ID   THREAD_ID STATEMENT_ID    STATEMENT_HASHWORKLOAD_CLASSUSED_GB   ALLOC_GB  ALLOC_MB_PER_SLIMIT_GBDB_USER             CLIENT_HOSTCLIENT_PIDCOMPONENTSTATEMENT_STRING
    1any   any%Pool/RowEngine/QueryExecution/SearchAllocany           225071352843       any             anyany           any           30.09281.360.34     anyUSER1            any        anyany  any             
    2any   any%Pool/RowEngine/QueryExecution/SearchAllocany           12800311472       any             anyany           any           17.33237.340.71     anyUSER1            any        anyany  any             
    3any   any%Pool/RowEngine/QueryExecution/SearchAllocany           2258181       any             anyany           any           09.974.31     anySYSTEM              any        anyany  any             
    4any   any%Pool/RowEngine/QueryExecution/SearchAllocany           27299879       any             anyany           any           070.460.66     anyUSER1            any        anyany   any             
    5any   any%Pool/RowEngine/QueryExecution/SearchAllocany           27247953       any             anyany           any           022.450.99     anyUSER1          any        anyany any             
  • For some situations, there might a few connections each consuming a little memory while all those connections add together consuming a lot of memory.

"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

SAP HANA, platform edition

Product

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

Keywords

M_CONTEXT_MEMORY, Pool/RowEngine/QueryExecution/SearchAlloc, M_CONNECTIONS, dbs/hdb/stmt_cache_size , KBA , HAN-DB-ENG , SAP HANA DB Engines , 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.