SAP HANA Cockpit: Alerts

Video Tutorial

In this video tutorial, we show how to work with alerts using the Alerts card on System Information and the associated view. You will learn how to enable and schedule alerts, define thresholds and run a check. We also show how you can deal with alerts and consider with the proposed solution.

What’s Changed?

E-mail notification is not available for Alerts.

SAP HANA Cloud – SAP HANA Cockpit: Alerts

Alerts

SAP HANA Cockpit

Alerts is a card (tile) on the System Overview page of the SAP HANA cockpit. It displays the number of high and medium alerts in a category and KPA (key performance area) view. The card also contains a link to the Alert Definitions view.

Alerts (card)

When selected, Alerts opens (view/app), listing all alerts with a header with search and filter functionality. We can filter on

• Type: past and present
• Priority: Error, High, Medium, Low, Information
• Time: 24 hours, 7 days, last 30 days, range, none
• Category (CPU, Disk, Memory, Security, Availability, etc.)

Alerts (view)

When selected, a detailed view of the alert occurrence is displayed, including proposed solution and past occurrences (24 hours, 7 days, last 30 days).

Alerts (details)

Alerting and Diagnostics

The Alert Definitions link on the Alerting and Diagnostics card opens the Alert Definitions view. Other ways to open this view is by selecting the Alert Definitions link on the Alerts card (see above) or by selecting the Alert Definitions link on the Alerts view (see above).

Alerts Definition

SAP HANA Cloud uses the same internal monitoring infrastructure as the SAP HANA platform (on-premise) edition and working with alerts in the SAP HANA cockpit is the same.

For the documentation, see

• Monitoring Resources, Alerts – SAP HANA Cockpit, SAP HANA Cloud

For more detailed information about each of the alerts defined and available for SAP HANA cockpit, there is a knowledge base article (KBA) on the SAP Help Portal. Similar information is also found in the Alerts Reference of the Troubleshooting and Performance Analysis Guide.

• 2445867 – How-To: Interpreting and Resolving SAP HANA Alerts
• Alerts Reference – SAP HANA Troubleshooting and Performance Analysis Guide, 2.0 SPS 04

For each alert, the ID, name, description, and how to handle information is provided, pointing to additional KBA’s as appropriate.

Note that not all alerts are applicable to SAP HANA Cloud.

How-To: Interpreting and Resolving SAP HANA Alerts

Alerts Reference – SAP HANA Troubeshooting and Performance Analysis Guide (platform, on-premise)

SAP HANA Database Explorer

Data about alerts is stored in the _SYS_STATISTICS schema. To access these tables you need the CATALOG READ system privilege and SELECT on the schema, or UPDATE, INSERT, DELETE in case you want to make changes.

Alert definitions are stored in the STATISTICS_ALERT_DEFINITIONS table.

Alert history is maintained in the STATISTICS_ALERT_BASE table.

For even more detailed information, check the FAQ about the statistics server although, again, not all information will apply to SAP HANA Cloud

• 2147247 – FAQ: SAP HANA Statistics Server

_SYS_STATISTICS.STATISTICS_ALERT_DEFINITIONS

_SYS_STATISTICS.STATISTICS_ALERT_BASE

The view trace and diagnostic files link on the Alerting and Diagnostics card opens, as indicated by the icon, the database explorer with the Database Diagnosis Files selected in the left pane. From here you can select the directory (folder) of the service and then select the <service>_alert file.

Alert files provide very detailed information but this is typically for advanced debugging purposes by SAP support and development.

Share and Connect

Questions? Post as comment.

Useful? Give a like and share on social media. Thanks!

If you would like to receive updates, connect with me on

• LinkedIn > linkedin.com/in/dvankempen
• Twitter > @dvankempen

For the author page of SAP Press, visit

• Denys van Kempen | SAP Press

For the SAP HANA Cloud e-bite, see

• Introducing SAP HANA Cloud