on 09-01-2016 6:43 PM
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Unless you have a runtime dump + kernel profiler whilst the CPU spiked then there is no definite way of identifying the issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.