Check Memory Usage and DB Size on HANA via SQL

You can use the following SQL queries to check your HANA system’s memory usage details…

List out the top 100 memory usage in HANA database between a specified date and time ;

select top 100 round(TOTAL_MEMORY_USED_SIZE/1024/1024/1024, 2) as
“Used Memory GB”, HOST, SERVER_TIMESTAMP from _SYS_STATISTICS.HOST_SERVICE_MEMORY where SERVER_TIMESTAMP between ’01.04.2018 08:00:00′ and ’02.04.2018 18:00:00′ order by TOTAL_MEMORY_USED_SIZE desc

Check Memory Usage on HANA

Check the peak memory usage ;

select top 1 HOST, SERVER_TIMESTAMP, round(TOTAL_MEMORY_USED_SIZE/1024/1024/1024, 2) as “Used Memory GB” from _SYS_STATISTICS.HOST_SERVICE_MEMORY where SERVICE_NAME = ‘indexserver’
order by TOTAL_MEMORY_USED_SIZE desc

Check Memory Usage on HANA

Check HANA DB Size ;

select sum(allocated_page_size) from m_converter_statistics 

Check Memory Usage on HANA via SQL

 

 

 

Leave a Reply


1 + = nine

Blogroll