To monitor table statistics is useful to detect potential performance or optimization problems. This monitor will check for the number of records and delta records as well as memory and disk usage of the column store tables.
You can detect and alert on:
The monitor evaluates:
Aggregate=true creates one alarm per rule and metric type (count of breached tables).Aggregate=false creates detailed alarms per matching table (and partition where applicable).Exclusive=true prevents matched tables from being evaluated by subsequent rows.Memory or Disk threshold > 0 AND Memory and disk used space is greater than 1MBRecord threshold > 0 AND Number of records are greater than 5000Delta Records threshold > 0 AND Number of delta records are greater than 500| Field | Required | Default | Description |
|---|---|---|---|
| Active | Yes | true | Enables or disables this surveillance row. |
| Schema | Yes | * | Schema filter (wildcards supported). |
| Table | Yes | * | Table filter (wildcards supported). |
| Table type | Yes | NON_PARTITIONED | Filter by table type: all, partitioned, or non-partitioned. |
| Records threshold | Yes | 0 | Alarm when record count is greater than or equal to this value. |
| Max delta memory | Yes | 0 | Alarm when delta memory is greater than or equal to this size threshold (K, M, G, T supported). |
| Max delta records | Yes | 0 | Alarm when delta record count is greater than or equal to this value. |
| Max disk usage | Yes | 0 | Alarm when disk usage is greater than or equal to this size threshold (K, M, G, T supported). |
| Aggregate | Yes | true | If enabled, sends aggregate alarms (count of matching breached tables). If disabled, sends per-table alarms. |
| Severity | Yes | MAJOR | Alarm severity used when a threshold is breached. |
| Auto clear | Yes | true | Alarms are clearable when condition recovers. |
| Exclusive | No | false | If enabled, matched tables are excluded from later rows. |
| Prefix | No | (empty) | Optional alarm prefix/tag text added to generated alarms. |
| Alarm | No | true | Enables or disables alarm generation for this row. |
| Metric | No | false | Enables or disables metric emission for this row. |
| metricId | metricUnit | metricTarget | metricDescription |
|---|---|---|---|
| TABLE_RECORD_COUNT | Records | SCHEMA.TABLE | Sends the number of records per CS table |
| TABLE_DELTA_RECORD_COUNT | Records | SCHEMA.TABLE | Sends the number of delta records per CS table |
| TABLE_DELTA_MEMORY | MegaBytes | SCHEMA.TABLE | Sends the used memory per CS table |
| TABLE_DISK_USAGE | MegaBytes | SCHEMA.TABLE | Sends disk used space per CS table |