Products documentation

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== HANA tables ======
===== Purpose =====
  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.

===== What Can Be Monitored =====
You can detect and alert on:
  * Tables with too many records
  * Tables with too many delta records
  * Tables with excessive delta memory usage
  * Tables with excessive disk usage
  * Partitioned or non-partitioned tables specifically
  * This helps identify data growth risks, memory pressure, and storage hotspots before they impact performance.
===== Monitored Data =====
The monitor evaluates:
  * Host
  * Schema
  * Table name
  * Partition id
  * Record count
  * Delta records count
  * Delta memory usage
  * Disk usage
===== Configuration Hints =====
  * One surveillance row defines one rule set (filters + thresholds + alarm behavior).
  * Set a threshold to 0 to disable that specific check for the row.
  * Table type can target all tables, only partitioned tables, or only non-partitioned tables.
  * ''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.
  * At least one active row must have at least one threshold greater than 0, otherwise the monitor does not run.

  * Metrics will be sent following below conditions:
    * ''Memory or Disk threshold > 0'' **AND** Memory and disk used space is greater than 1MB
    * ''Record threshold > 0'' **AND** Number of records are greater than 5000
    * ''Delta Records threshold > 0'' **AND** Number of delta records are greater than 500
===== Surveillance table =====
^ 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. |
===== Generated metrics =====
^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|