HANA Peak Memory

[Former Member]

All,

Is there any way that I can check what caused the Peak Memory spike on HANA? I can isolate the usage to an interval of around 2 hours but have not fund a way of checking historical statistics. I have not checked the trace files yet as was hoping there was an easier way? Ideally I would like to see whether this was a result of user initiated queries or if something internal to HANA was running.

Thanks

Kris

[AtulKumarJain]

Hi Kris,

Please go through below doc you will get good idea about memroy usages in HANA

http://www.saphana.com/docs/DOC-2299

BR

Atul

[vivekbhoj]

Hi Kris,

You can check the blog by Andy Silvey:

http://scn.sap.com/community/hana-in-memory/blog/2013/05/27/andy-silvey--sap-hana-command-line-tools...

Go to point 27 and there you can find that you can use hdbcons tool to provide information about the actual used memory, the peak memory,etc.

You can also check SAP Note 1786918 - Required information to investigate high memory consumption

Regards,

Vivek