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

[rajarajeswari_kaliyaperum]

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

select HOST, left(SERVER_TIMESTAMP,25) 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/09/11 00:00:00'order by SERVER_TIMESTAMP

If you do not have access to statistics server to get the above output , you can also use the system view M_LOAD_HISTORY_SERVICE . However, this system view will have much lesser data when compared to _SYS_STATISTICS.HOST_RESOURCE_UTILIZATION

select * from M_LOAD_HISTORY_SERVICE where TIME > '2020-08-10 00:08:00'

Hope it helps!!

Thanks for reading!
Follow for more such posts!
Like and leave a comment or suggestion if any!