Collector for HANA alerts
The technical name of the Collector for HANA Alerts is /DVD/MON_HDB_CL_COL_ALERT.
This collector collects the number of records that appear in the table _SYS_STATISTICS.STATISTICS_ALERTS_BASE according to their alert rating as a different KPI. The number of these KPIs is only counted for the last snapshot, i.e. it only checks alerts that have been triggered since the last collector execution.
The KPIs created for this purpose are based on the alert rating:
|
KPI name |
Alert rating |
|---|---|
|
HDB_ALERT_INFORMATION |
1 |
|
HDB_ALERT_LOW |
2 |
|
HDB_ALERT_MEDIUM |
3 |
|
HDB_ALERT_HIGH |
4 |
|
HDB_ALERT_ERROR |
5 |
Default KPIs Delivered with This Collector
The following default KPIs are delivered with this collector:
| KPI name | Description | Unit | Detail Table |
|---|---|---|---|
| HDB_ALERT_INFORMATION | HANA alert type - information | count | Yes |
| HDB_ALERT_LOW | HANA alert type - low | count | Yes |
| HDB_ALERT_MEDIUM | HANA alert type - medium | count | Yes |
| HDB_ALERT_HIGH | HANA alert type - high | count | Yes |
| HDB_ALERT_ERROR | HANA alert type - error | count | Yes |
Detail table
The collector provides detailed output for the occurred HANA alerts into detail table HANA alerts. The technical name of this detail table is /DVD/MON_HDB_S_ALERT_LIST and it contains the following fields:
|
Technical name |
Description |
|---|---|
|
SERVER |
Server |
|
KPI_NAME |
KPI name |
|
PRIORITY |
Information about how severe the alert is. Possible values:
|
| ALERT_ID | Numerical identifier of the alert |
|
DESCRIPTION |
Alert description |
|
COUNT |
Count of same alerts for the defined timestamp. |
