(DI-2308) Collector for HANA Backups
- SNP
The technical name of the Collector for HANA Backups is /DVD/MON_HDB_CL_COL_BCK.
This collector collects information about Data/Log backups according to the view M_BACKUP_CATALOG and also collects the statistics for Log buffers (M_LOG_BUFFERS) and Segments (M_LOG_SEGMENTS).
Default KPIs delivered with this collector
The following default KPIs are delivered with this collector:
KPI name | Description | Unit | Detail table |
|---|---|---|---|
HDB_BCK_DELAY_D | Time since last successful DATA backup | H | No |
HDB_BCK_DELAY_L | Time since last successful LOG backup | Min | No |
HDB_BCK_FAILED | Number of failed backups | Count | No |
HDB_BCK_FAIL_DAT | Number of failed DATA backups | Count | No |
HDB_BCK_FAIL_LOG | Number of failed LOG backups | Count | No |
HDB_LOG_BUFWAITP | Buffer switches with Wait on buffer semaphore % (max host) | % | Yes |
HDB_LOG_BUFWAITT | Number of Buffer switches wait since last check | Count | Yes |
HDB_LOG_BUFWNOWT | Number of Buffer switches (noWait+wait) since last check | Count | Yes |
HDB_LOG_SEG_FREE | Minimum number of Free log segments (per hosts) | Count | Yes |
HDB_LOG_SEG_TRNC | Maximum number of Truncated log segments (per hosts) | Count | Yes |
Detail table
The collector provides detailed table HANA Log buffer details. The technical name of the detail table is /DVD/MON_HDB_LOGBUF_DETAIL.
HANA Log buffer details provide a processed log buffer retrieved from view M_LOG_BUFFERS with some additional calculated statistics. It contains the following fields:
Technical name | Description |
|---|---|
TIMESTAMP | When the records are saved into the Detail table |
SID | System ID |
HOST | Host |
PORT | Port |
VOLUME_ID | Volume ID |
SERVICE_NAME | Service name |
SWITCH_NOWAIT_C | Switch NoWait Count |
SWITCH_WAIT_C | Switch Wait Count |
WAIT_NOWAIT | Previous Ratio Wait Nowait |
FREE_SEGMENT | Number of free segment |
TRUNC_SEGMENT | Number of truncated segment |
DELTA_NOWAIT_CNT | Delta NoWait Count |
DELTA_WAIT_CNT | Delta Wait Count |