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 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 HANA DB Size ;

select sum(allocated_page_size) from m_converter_statistics