HANA memory usage in detailed

[Former Member]

Hi All,

We have an issue where we have some X amount of TB occupied.

Now the whole memory is not table data right.

We have the two parts of memory basically right.

One would be the space occupied by tables and other is the areas for HANA to function.

Now how do I get a detailed description for the space occupied in memory exclusively by tables (row and column store) and other part occupied dynamically ?

[former_member315195]

Hi,

Please try to use the system information Tab in HANA studio- Administration console. There is one view called Component Memory Usage. Hope this can help you!

[Former Member]

I have calculated the memory used by tables using M_TABLES view and it comes around 1.2 TB.

When calculated database used memory from M_MEMORY using the name TOTAL_MEMORY_SIZE_IN_USE.

It comes around 2.2 TB.

What all dynamic data in memory is hana populating, how do we get to know more about it?

[Former Member]

Memory overview .Sql from the Note , will give you the details

1969700 - SQL statement collection for SAP HANA

[Former Member]

Hi Pavan,

I don't think so memory overview sql talks about the points which I had raised.

[Former Member]

The points are crucial since we need to estimate as to how long HANA will last for us depending on the data growth.

[Former Member]

Hello,

To your question:

"Now how do I get a detailed description for the space occupied in memory exclusively by tables (row and column store) and other part occupied dynamically ?"

You can use the SAP HANA Cockpit. Depending of what is your HANA Revision:

Single-container system: http://<host>:<port>/sap/hana/admin/cockpit

System database of a multiple-container system: http://<host>:<port>/sap/hana/admin/cockpit

Tenant database in a multiple-container system: http://<alias_DNS_name_of_tenant_DB>:<port>/sap/hana/admin/cockpit

Here you will get the following:

In order to login into the SAP HANA Cockpit please look at the Hana Admin Guide of your SPS.

Hope it helps.

Best Regards,

Erick Ilarraza

[Former Member]

Thanks a ton for the information. Will check out the information, I think its the same screen as to what we see from hana studio--> service--> memory allocation statistics.

[Former Member]

Hello,

I would kindly suggest to check this guide:

http://help.sap.com/hana/SAP_HANA_Troubleshooting_and_Performance_Analysis_Guide_en.pdf

Please check the guide for your HANA Release.

Best Regards,

Erick Ilarraza

[gowrisankar_m2]

Hello ,

Can you check below links,

http://www.freehanatutorials.com/2012/11/query-to-check-hana-memory-usage.html

http://saphanatutorial.com/sap-hana-memory-usage-explained/

[Former Member]

Hello,

Just starting at this thread will help you a lot:

Followed by a visit to the reference note by

1969700 - SQL statement collection for SAP HANA

Happy reading.

KR,

Amerjit

[Former Member]

Hi Amerjit,

I did check the sql collection from martin, in fact I use it a lot . But I don't think so it contains the points which I had raised may be I missing something.

[param0308]

Hi ,

You can use this query for all used memory by HANA

select HOST, round(INSTANCE_TOTAL_MEMORY_USED_SIZE/1024/1024/1024, 2) as "Used Memory GB" from M_HOST_RESOURCE_UTILIZATION

or you can service wise also

select HOST, round(TOTAL_MEMORY_USED_SIZE/1024/1024/1024, 2) as "Used Memory GB" from M_SERVICE_MEMORY where SERVICE_NAME = 'indexserver' 

Regards

[Former Member]

Rajender,

Can you please check my question again.