Skip to Content
May 05, 2016 at 07:02 AM

how to calculate hana memory usage using view HOST_RESOURCE_UTILIZATION_STATISTICS


Hi all,

I want to know the actual HANA memory usage to estimate how long HANA will last for us depending on the data growth. I used SQL "HANA_Resources_CPUAndMemory_History" in note 1969700. But the calculated result for memory usage is beyond our expect. The sql result shows memory usage is more than 60% , but according to our statistic data the table size is only occupied 30% memory.

So I check the sql statement and found it takes field "USED_PHYSICAL_MEMORY" as the used memory(numerator ), but there is another field "INSTANCE_TOTAL_MEMORY_USED_SIZE" , the value of the latter is much smaller.

So I have two questions:

1. Why the memory usage got from sql is much bigger than the memory shows in Hana studio- Administration-Lanscape.?

2. If I want to know the actual used memory, I should choose which field in view HOST_RESOURCE_UTILIZATION_STATISTICS?

Hope anyone can help me.