How to find out the maximum amount of memory hit by HANA per day

Maximum hit memory per day:

If you want to find out what is the maximum memory that HANA has hit per day basis , you can use the below query

========

with CST as (

select HOST, left(SERVER_TIMESTAMP,10) as date,round(INSTANCE_TOTAL_MEMORY_USED_SIZE/1024/1024/1024, 2) as MemGB from _SYS_STATISTICS.HOST_RESOURCE_UTILIZATION_STATISTICS where HOST = ‘<HOST_NAME>’ and SERVER_TIMESTAMP > ‘2020/06/01 00:00:00’order by SERVER_TIMESTAMP)

select distinct date, max(MemGB) from CST group by date order by date;

==========

Modify as per your requirement with respect to date field and Host name field in the above query .

Sample Output:

==============

Note The statistics server continues to record memory consumption at regular interval and the same can is stored in the table _SYS_STATISTICS.HOST_RESOURCE_UTILIZATION_STATISTICS