(DI-1911) Collector for HANA alerts

Owned by SNP
Mar 05, 2019

Collector for HANA alerts name: /DVD/MON_HDB_CL_COL_ALERT

Collector collects 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 last snapshot (checking only alerts triggered since 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
ServerServer
Kpi_nameKPI name
SeverityInformation about how sever is the alert ( information, low, medium, high. error)
DescriptionDescription
CountCount of same alerts for defined timestamp.