Question Re: CPU usage history in Technology Q&A

CPU usage history

former_member221632 — Thu, 28 May 2015 13:24:09 GMT

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?

Re: CPU usage history

Former Member — Thu, 28 May 2015 20:30:36 GMT

You can use SQL: "HANA_Resources_CPUAndMemory_History" (SAP Note 1969700) for that purpose. Check the embedded documentation for details and make sure that you configure the "Modification section" based on your individual needs.

Re: CPU usage history

former_member221632 — Fri, 29 May 2015 12:24:14 GMT

Hi Martin,

Thanks for the OSS Note, it's a really very helpful note. I'm running the SQL mentioned in 'HANA_Resources_CPUAndMemory_History'. It is giving the output for every hour, not every minute as mentioned in it. If you could help me, where I need to change in the the below SQL so that I get the result every minute? Sorry I'm poor in SQL.

SELECT

///---- cut out by moderator -----///

( SELECT /* Modification section */

TO_TIMESTAMP('2015/05/28 00:00:00', 'YYYY/MM/DD HH24:MI:SS') BEGIN_TIME,

TO_TIMESTAMP(2015/05/29 12:00:00', 'YYYY/MM/DD HH24:MI:SS') END_TIME,

'%' HOST,

' ' ONLY_SWAP_SPACE_USED,

-1 MIN_MEMORY_UTILIZATION_PCT,

-1 MIN_CPU_UTILIZATION_PCT,

'NONE' AGGREGATE_BY, /* HOST, TIME or comma separated list, NONE for no aggregation */

'HOUR' TIME_AGGREGATE_BY, /* HOUR, DAY, HOUR_OF_DAY or HANA time pattern, NONE for no aggregation */

'TIME' ORDER_BY /* TIME, HOST */

FROM

DUMMY

)

///---- cut out by moderator -----///

Message was edited by: Lars Breddemann

Re: CPU usage history

lbreddemann — Fri, 29 May 2015 15:53:46 GMT

Hey "Competency Center",

please don't SPAM this forum with copy&pasting massive coding parts without putting in any own work.

Please do your share of effort and read the documentation of the scripts.

The SAP note where you got the script from explains how to configure the scripts.

I did you the favor in cutting out the parts of the scripts that are irrelevant to the configuration, leaving just the important part.

Now, you should be able to find the part where you can choose the aggregation level.

Just actually read the documentation and the comments for this script.

- Lars

Re: CPU usage history

Former Member — Fri, 29 May 2015 16:25:40 GMT

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.

Re: CPU usage history

former_member221632 — Mon, 01 Jun 2015 11:55:47 GMT

Thanks Martin, it helped to get the desired stats.