(DI-2102) Collector for HANA alerts

Owned by SNP
Feb 01, 2021

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 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 sever is the alert ( information, low, medium, high. error)
DescriptionDescription
CountCount of same alerts for defined timestamp.