Alerting Cards in SAP HANA Cockpit

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Use the SAP HANA Cockpit alerting cards

SAP HANA Cockpit - Alerts Card

Lesson Overview

In this lesson, you will learn how to use the alerting framework available in the SAP HANA cockpit provided in the SAP BTP.

You can also change the alert attributes provided in the alerting framework available in the SAP HANA cockpit provided in the SAP BTP.

Business Case

As an administrator, using the alerting framework, you can proactively monitor the status of the SAP HANA Cloud database instance. With the alerting framework you are alerted to critical situations, for example: a disk is becoming full, CPU usage is reaching a critical level, or a server has stopped.

The internal monitoring infrastructure of the SAP HANA database is continuously collecting and evaluating information about status, performance, and resource usage from all components of the SAP HANA database. In addition, it performs regular checks on the data in system tables and views and when configurable threshold values are exceeded, it issues alerts. In this way, you are warned of potential problems. The priority of the alert indicates the severity of the problem and depends on the nature of the check and the configured threshold values. For example, if 90% of available disk space has been used, a low priority alert is issued; if 98% has been used, a high priority alert is issued.

SAP HANA Cockpit - Alerts Card

In the SAP HANA cockpit - Database Overview page, search for the Alerts card (1).

The Alerts card (2) shows the current alerts of the SAP HANA Cloud database. Multiple alerts can be shown. Their status can be High or Medium depending of the severity of the detected problem.

Clicking on the Alerts card opens the Alerts app (3) which gives a detailed breakdown of all the current alerts in your SAP HANA Cloud database.

On the Manage Alerts page, the default summary list includes all current alerts with a priority of high, medium, and error. You can filter, sort, and view details in the search area (1) as needed.

In the Alerts display area (2) you see detailed information on the available alerts. The columns provide the following information.

  • Priority - Indicates the severity of the alert and how quickly action needs to be taken. The following priorities are possible:
    • Information - Action is recommended to improve system performance or stability.
    • Low - Medium-term action is required to mitigate the risk of downtime.
    • Medium - Short-term action is required (few hours, days) to mitigate the risk of downtime.
    • High - Immediate action is required to mitigate the risk of downtime, data loss, or data corruption.
    • Error - Immediate action is required to fix the issue. Use trace files to help track and resolve the issue.
  • Alert - Provides a description of the alert.
  • Time - Indicates the time that the alert was triggered.
  • Alerting Host & Port - Provides the name and port of the host that issued the alert.
  • Source - Indicates where the alert originated from.
  • Category - Indicates the category of the alert checker that issued the alert. Alert checkers are grouped into categories. The categories are:
    • Availability
    • Backup
    • Configuration
    • CPU
    • Diagnosis Files
    • Disk
    • Memory
    • Other
    • Security
    • Sessions/Transactions

Click on alert to see its definition and more details, such as past occurrences, proposed solutions, and next scheduled runs.

Use the Alerts Card

SAP HANA Cockpit - Alert Definitions App

Business Case

As a database administrator, you want to customize several SAP HANA Cloud alert attributes to be able to monitor the cloud databases with the same KPIs as the on premise databases.

Changing the Alert Definitions

The Alerts in the SAP HANA Cloud database instance come with default threshold values and repeat intervals. Customize the threshold values to your own companies standards. In this way the SAP HANA Cloud database complies to the same monitoring standards as the on premise databases.

In the SAP HANA cockpit - Overview page search for Alert Definitions. The Alert card is found that has a link Alert Definitions. Open the Alert Definitions app by clicking the link.

Hint
Alternatively, you can use the Alert Definitions link in the Alerting and Diagnostics card.

Use the search (2) fields to quickly find the alert you need to customize. You can search via:

  • Status - Display the Alert status (Active, Inactive)
  • Last Run - Show alerts that ran never, or in the last 2, 10 or 120 minutes.
  • Category - Alerts that belong together are grouped in categories. The following categories exist Availability, Backup, Configuration, Diagnosis Files, Disk Memory, Other Security and Session/Transactions.
  • Source - Alters can originate from different sources like e.g. SAP HANA database
  • Alert Definition - Free text filter on the Alert Definition texts.

A list of available alerts is shown. Select a Alert Definition (3) to open the Alert Definition details.

See the following video for changing the Alerts Definition properties.

Use the Alert Configuration

Save progress to your learning plan by logging in or creating an account