on 10-01-2015 11:32 PM
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 ?
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Memory overview .Sql from the Note , will give you the details
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.