CPU usage history
How do we get the CPU usage history for the HANA database? Our HANA systems are on SPS08. I can collect the memory stats from the table _SYS_STATISTICS.HOST_SERVICE_MEMORY
Also if i click on Dashboard monitoring in HANA studio & click on CPU usage, it shows no data.
Some queries are going to be run tomorrow & we need to collect the CPU/memory stats during that time. What is the best way to do this?
You have to change the TIME_AGGREGATE_BY value from 'HOUR' to 'NONE', then you will get the information on the most granular (minutes) level.