(DI-1808) Collector for HANA alerts

Owned by SNP
Dec 15, 2017

Collector for HANA alerts name: /DVD/MON_HDB_CL_COL_ALERT

Collector collects amount of records appearing in table _SYS_STATISTICS.STATISTICS_ALERTS according to their alert rating as different KPI.  Amount of these KPIs is counted only for last snapshot.

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.