(DI-2005) Collector for HANA alerts

Owned by SNP
Last updated: Jun 24, 2020 by Marian Vidra
1 min read

Collector for HANA alerts name: /DVD/MON_HDB_CL_COL_ALERT

Collector collects the amount of records appearing in table _SYS_STATISTICS.STATISTICS_ALERTS_BASE according to their alert rating as different KPI.  Amount of these KPIs is 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 nameAlert 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 list of found alerts with fields:
SERVER, KPI_NAME, SEVERITY, DESCRIPTION, COUNT.

FieldDescription
ServerName of the server
KPI_nameName of the KPI
SeverityInformation about how sever is the alert (information, low, medium, high. error)
DescriptionDetailed description
CountCount of the same alerts for defined timestamp.