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 .
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
select * from M_LOAD_HISTORY_SERVICE where TIME > ‘2020-08-10 00:08:00’
Follow for more such posts!
Like and leave a comment or suggestion if any!