HANA Peak Memory

[former_member196555]

Dear Colleagues,

We received an alert from Solution Manager about HANA peak memory utilization reaching to 96%.

We did not run any trace at that time. I do have time stamps with me for the peak memory.

Is there a way to check what SQL statements or other activities would have run during that time stamp?

Thank you.

Warm Regards,

Harshad

[Former Member]

Hi Harshad please check system monitoring tables

SAP HANA Reference: M_MEMORY

SAP HANA Reference: M_SERVICE_COMPONENT_MEMORY

SAP HANA Reference: M_MEMORY

To display the current size of the Used Memory, you can use the following simple SQL statement

select HOST, round (INSTANCE_TOTAL_MEMORY_USED_SIZE/1024/1024/1024, 2) as "Used Memory GB" from M_HOST_RESOURCE_UTILIZATION.

hdbcons is a tool to provide information about the actual used memory, the peak memory,

the throughput of the different allocators, etc.

SAP Note 1786918 - Required information to investigate high memory consumption

You are running SAP HANA and you experience high memory consumption / out

of memory situations. Hope it helps you .

Best regards

poorna