HANA memory issue analysis

[SriKrishna]

Hello SDNers,

the below chart is generated from the output of HANA_Resources_CPUAndMemory_History_Rev74+_ESS query.

as can be seen,memory utilization almost reached allocation limit for some time. There are some unloads at that time to compensate.

and used query HANA_Memory_TopConsumers_History, got the top memory consumers.

so, my doubt is, can we see in HANA something like /sdf/mon, which lists all the executing processes and PIDs at any point in time.

in addition to top consumers, as obtained in output of HANA_Memory_TopConsumers_History, can we also get corresponding connection IDs, client PIDs etc.

or is it possible to view this only with trace on?

Please provide your views.

[Bojan-lv-85]

Hello Krishna,

I am quite sure you will find the information you are looking for in

1999997 - FAQ: SAP HANA Memory

especially pt. 3 might be of interest.

You would  need to enable the memory tracking and expensive statements trace. All information on how to activate those you can find in above mentioned note.

BR, Bojan