SAP Knowledge Base Article - Preview

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

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.

1.jpg

  • In Solution Manager, you would find the alert using transaction DBACOCKPIT -> choose HANA system -> expand Current Status -> Alerts.

2.jpg

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.

3.jpg


Read more...

Environment

SAP HANA Database

Product

SAP HANA, platform edition all versions

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 Messages , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.