Tuesday 18 July 2023

SAP HANA Database Monitoring & Alerting

 As Database administrators, we need to actively monitor the system status and its services and the consumption of system resources. However, we received alerts about critical situations, for example, a disk is becoming full, CPU usage is reaching a critical level, or a server has stopped.

SAP HANA database internal monitoring infrastructure continuously collects and evaluates information about status, performance and resource usage from all components of the SAP HANA Database. 

Alerts are displayed according to the following time periods:

Time PeriodAlerts Displayed
Last 15 minutes, last 30 minutes, last hour, last 2 hours, and todayAlerts generated in the corresponding time period are shown. If an alert was generated 10 minutes ago, it appears under all these headings.
YesterdayOnly alerts that were generated yesterday are shown.
Last weekOnly alerts generated during the previous week (Sunday to Saturday) are shown.
Two weeks ago, and so onOnly alerts generated during that week are displayed.


To find specific alerts we can do a search in the alert tab by entering the word in the Filter field like OOM or High CPU 

o filter according to additional attributes including priority and date of occurrence, choose the Filters Filters button in the toolbar on the top-right of the tab and select the required filter(s).

 Alert Information

You can view the detailed information about an alert by double-clicking it. The Alert Details dialog box appears with information including:

  • A full description of the alert
  • The timestamp for this occurrence of the alert
  • Information about how to resolve the alert
  • A list of previous occurrences of this alert

The Copy button in the Alert Details dialog box allows you to copy the details of the alert to the clipboard, including its time(s) of occurrence. Note that only the 10 most recent occurrences are copied. Further occurrences are indicated by an ellipsis (...)

SAP HANA Administration with SAP HANA Studio Guide



Thanks 

Rupesh Chavan