Skip to Content

HANA memory issue analysis

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.

aaa.png (29.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 27, 2015 at 10:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded