Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
dvankempen
Product and Topic Expert
Product and Topic Expert
1,820

SAP HANA Cockpit: Alerts









In the upcoming days and weeks, we will be publishing new tutorial videos about what's new and changed for SAP HANA Cloud. The focus of this series is on system administration with SAP HANA cockpit.

For the overview blog about What's New with SAP HANA Cloud Administration, see

Questions? Post as comment.

Useful? Give us a like and share on social media.

Thanks!



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.

https://www.youtube.com/watch?v=F3XHy9GzsbI
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

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.

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



_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

For the author page of SAP Press, visit

For the SAP HANA Cloud e-bite, see

6 Comments