Query to check HANA Memory Usage ?

Heap Memory used size.png


  1. Heap Memory used size for Index server in : select * from M_memory where name = 'HEAP_MEMORY_USED_SIZE' --- Please check for your Indexserver
  2. Shared Memory used size for Index server in : select * from M_memory where name = 'SHARED_MEMORY_USED_SIZE'
  3. Column Store Memory used size : SELECT round(sum(MEMORY_SIZE_IN_TOTAL)/1024/1024) AS "Column Tables MB" FROM M_CS_TABLES;
  4. Row Store Memory used size : SELECT round(sum(USED_FIXED_PART_SIZE + USED_VARIABLE_PART_SIZE)/1024/1024) AS "Row Tables MB" FROM M_RS_TABLES;
  • Memory in Code and Stack: SELECT round(sum(CODE_SIZE+STACK_SIZE)/1024/1024) AS "Code+stack MB" FROM SYS.M_SERVICE_MEMORY;
  • Total Used memory: SELECT round(sum(TOTAL_MEMORY_USED_SIZE/1024/1024)) AS "Total Used MB" FROM SYS.M_SERVICE_MEMORY;



Additional Info:
Query to Check Delta memory for COLUMN tables
select * from m_cs_tables where memory_size_in_delta > 1000;



Tags: HEAP_MEMORY_USED_SIZE , HANA MEMORY , INDEX SERVER MEMORY UTILIZATION, QUERY TO CHECK HANA MEMORY, 
Share this article :

Post a Comment

 
Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved