1909670 - How to handle HANA Alert 5: ‘Host CPU Usage'

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

SAP HANA Database

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