Symptom
The HANA system becomes unresponsive.
When checking the Alerts tab, there is an alert with a description such as “suse-hanajl01 runs out of CPU resources! CPU consumption user mode 0%, system mode 0%, wio 0%, idle 0%”
- In HANA Studio you would find the alert by directory Administration Console -> Alerts -> Show: all alerts.
- In Solution Manager, you would find the alert using transaction DBACOCKPIT -> choose HANA system -> expand Current Status -> Alerts.
Remember for this “Check host CPU utilization” alert in Solution Manager, it is auto-refreshed every 15 minutes, so the time stamp on the alert may be not the exact time when alert occurs.
To check the exact time, please go to Administration Console -> Alerts -> double click on the alerts -> more occurrence for this alert.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental
Read more...
Environment
SAP HANA Database
Product
Keywords
Operations Recommendation, #OpsRec-HANA; Check host CPU utilization; Configure Check Settings; Long running SQL statements; hanging jobs; HDBAdmin tool; sql trace; performance trace; , KBA , HAN-DB-MON , SAP HANA Monitoring , SV-PERF , Performance Problems , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.