(DI-2305) Collector for HANA alerts

Owned by SNP
May 03, 2023

Collector for HANA alerts name: /DVD/MON_HDB_CL_COL_ALERT

The collector collects the number of records appearing in the table _SYS_STATISTICS.STATISTICS_ALERTS_BASE according to their alert rating as different KPI.  The amount of these KPIs are counted only for the last snapshot (checking only alerts triggered since the last collector execution time).

KPIs created for this purpose are based on alert rating:

KPI name
Alert rating
HDB_ALERT_INFORMATION1
HDB_ALERT_LOW2
HDB_ALERT_MEDIUM3
HDB_ALERT_HIGH4
HDB_ALERT_ERROR5


Detail table /DVD/MON_HDB_S_ALERT_LIST contains the list of found alerts with fields:
SERVER, KPI_NAME, SEVERITY, DESCRIPTION, COUNT.

FieldDescription
ServerServer
Kpi_nameKPI name
SeverityInformation about how severe is the alert (information, low, medium, high. error)
DescriptionDescription
CountCount of same alerts for the defined timestamp.