Subject: Understanding and Optimizing OTHER_DYNAMIC Heap Memory Usage in SAP HANA

[seyfeddine]

Hello,

I am currently studying the Heap_Memory_Used_Size of M_SERVICE_MEMORY (the dynamic part of memory in HANA) and looking for ways to optimize memory usage.

I have identified three key components:

1. Memory used by procedures: This information is available in the view M_ACTIVE_STATEMENTS.
2. Memory used by temporary tables: This is found in the view M_TEMPORARY_TABLES.
3. Memory used by physical tables: This is found in the view M_CS_TABLES.

However, there is a part of heap memory labeled i call other_dynamic (all heap memory -Statement_memory -Temporary_tabeles - physical_tables)  that I do not fully understand. This memory allocation exists even when there is no activity in the database, and its value increases after a commit.

My questions are:

1. What specifically consumes the OTHER_DYNAMIC portion of heap memory in SAP HANA?
2. How can I optimize my database to reduce the memory consumed under OTHER_DYNAMIC?

Thank you for your assistance.