Hana memory issue

[former_member726237]

Hi Friends,

Our hana memory is increasing and it is about 79%, we have checked the tables etc, dont see what is causing the issue.

The pool/persistencemanager/persistentspace/defaultlpa/lobpage shows 56.4 GB usage.

when I checked free -g memory, out of the total memory of 1.5 TB the used is 85% and the cached memory is 109 gb which is less but the memory used to load the table and codes is around 159GB.

How to check if any linux caching has not obtained the major amount of used memory and if it is used how to analyze the same.

Also why is the cached memory less.

Any suggestions in this regard please.

Thanks

[former_member726237]

Please if you dont mind can you provide the query name, in case if i am executing wrong one.

[kbharg]

can you provide your mini checks logs pls

[kbharg]

Did you try to run the HANA mini check and see any deviation from expected for MEMORY segment?

[jasonluo]

Just to add, you can find the SQL code here:

1969700 - SQL Statement Collection for SAP HANA

https://launchpad.support.sap.com/#/notes/1969700

[former_member726237]

Thanks Bhargavi and Jason.

Yes,I am aware of the note and executed few sql queries, but nothing found.

I have executed top memory consumers, memory overview etc,. i dont see mini checks for memory, we have for configuration.

Any more suggestion please or can u let me know exact query name.

Regards