Unmechanical extended detailed walkthrough
You may want to adjust the modification section based on your situation. – HANA_Memory_TopConsumers_History_1.00.90+_ESS with the selection specific on time 09:00 – 10:35 on node01. We’ve narrowed down the time where peak memory happened, now let’s investigate what were those top memory components used on node01 with below script: What were the top memory consumers during peak usage
‘TS30’ TIME_AGGREGATE_BY, /* HOUR, DAY, HOUR_OF_DAY or database time pattern, TS for time slice, NONE for no aggregation */ ‘TIME’ AGGREGATE_BY, /* HOST, TIME or comma separated list, NONE for no aggregation */ In addition, you can also utilize script HANA_Resources_CPUAndMemory_History_1.00.74+_ESS attached to note 1969700 if you want to further break down the memory usage of the day: –
The result shown that peak memory happened on 7 th Jul, around 10:20 – 10:55AM Select top 500 HOST, SERVER_TIMESTAMP,round(INSTANCE_TOTAL_MEMORY_USED_SIZE/1024/1024/1024, 2) as “Peak Used GB” from _SYS_STATISTICS.HOST_RESOURCE_UTILIZATION_STATISTICS where HOST = ‘node01’ and SERVER_TIMESTAMP between ‘ 00:00:01’ and ‘ 23:59:59’order by “Peak Used GB” desc Node01: When was the specific time that the peak usage happened?įirst, we need to find out the specific day/ time the peak memory happened.įor my case, I knew the peak memory was occurred last week, and hence, I’m using the past week timestamp and below SQL script to figure the exact day/time of the peak memory. What were the running processes/ threads during the peak usage?.What were those top memory consumers during peak usage?.When was the specific time that the peak usage happened?.Thus, in this content, I’ll show the memory analysis on node01 and node02 by using the 3 simple questions as quick start, where it provides us a clearer direction moving forward: Since the system is running on scale out environment, I will breakdown the analysis of each memory usage of each node:īelow we noticed that the node01 and node02 are one of those nodes with high peak used memory. I’m taking below example where I was asked to perform a memory analysis on a productive system where there was a spike of peak memory usage, around 5.9TB.
#Unmechanical extended detailed walkthrough how to#
In this exercise, I’ll give a walkthrough on how to perform a top down investigation on high & peak HANA memory usage and its associate top memory consumers with the aid of HANA SQL scripts attached to SAP Note 1969700 – SQL Statement Collection for SAP HANA and Statistics data (History / Current) collected by ESS / SSS (Mandatory.