cancel
Showing results for 
Search instead for 
Did you mean: 

HANA high CPU

Former Member
0 Kudos

Hi Team,

I have a question, a situation occurred over the weekend where there was high CPU on one of the node. THis is a single node system.

My question is that if there is a way to find out if we can track which SQL caused the high CPU?

Thanks,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

You could start by following the write up by Michael Healy:

In the above you'll also find reference to: 2100040 - FAQ: SAP HANA CPU

KR,

Amerjit

Answers (3)

Answers (3)

lucas_oliveira
Advisor
Advisor
0 Kudos

Hi,

In addition to what and Former Member mentioned you can also use point 9. of SAP Note 2100040 if you do the investigati...

So in your case I doubt you'll be able to track back 5 days but it's worth the try.

Regards,

Lucas de Oliveira

former_member183326
Active Contributor
0 Kudos

Unless you have a runtime dump + kernel profiler whilst the CPU spiked then there is no definite way of identifying the issue.

Former Member
0 Kudos

Hi,

If you have the EXPENSIVE statement collection trace set to ON you can use the M_EXPENSIVE_STATEMENTS monitoring view to check for the expensive statements

If you know which user could have launched the query and the timestamp it is easy to fetch the SQL Statement that caused the CPU spike

Sunil