Pro.Monitor V6.8
- Install Promonitor
Trouble shooting
Monitors Guide
Sidebar
products:promonitor:6.8:monitorsguide:hana:hanatables
Book Creator
Add this page to your book
Add this page to your book Book Creator
Remove this page from your book
Remove this page from your book 
Manage book (
Help Table of Contents
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.
Configuration hints
- Add a new rule in the surveillance table to start monitoring tables.
- You can customize the thresholds and severities per schema and table name using the schema and table filters.
- You can set threshold for the following metrics:
- The number of records
- The number of delta records (not persistently written).
- The amount of delta memory (space used by delta records)
- The disk space used by the table The monitoring can be customized based on filter set on the schema, the table and the type of table (partitioned or not)
- Also, you must set at least one threshold if you want metrics to be sent.
Metrics: Caution
- If a “*” is used as table name filter, the number of metrics could be potentialy huge.
- We advise not to turn metrics on for such case, but only for a subset of tables.
- Metrics will be sent following below conditions:
- Memory and disk used space is greater than 1MB
- Number of records are greater than 5000
- Number of delta records are greater than 500
Surveillance table
| Parameter | Description |
|---|---|
| Active | If checked, the rule is enabled and will be processed |
| Schema | Can be used to restrict the monitoring on the tables within a given schema. A star (‘*’) will match any schema |
| Table | Can be used to restrict the monitoring on a given table. A star (‘*’) will match any table |
| Table type | Select the type of table to monitor between partitioned or non-partitioned |
| Records threshold | The threshold of the alarm on the maximum number of records |
| Max delta memory | The threshold of the alarm on the maximum number of delta records |
| Max delta records | The threshold of the alarm on the maximum delta memory (use KB/MB/GB units) |
| Max disk usage | The threshold of the alarm on the maximum disk used space (use KB/MB/GB units) |
| Delta time | The period of time used to make a delta comparison of the measured elements |
| Aggregate | If checked, one alarm will be sent indicating the number of tables reaching each threshold. Potentially, there could be one alarm per breached threshold. If not checked, one alarm per table breaching a threshold will be sent. Potentially, there could be one alarm per table and per threshold |
| Severity | Defines the level of severity of the alarm that will be generated if one of the thresholds is reached |
| Auto clear | If set, the generated alarms will be automatically cleared from the console if the alarm condition is not fulfilled anymore |
| Alarm tag | You can define some text to use as a prefix of the alarm message generated by the current rule |
| Alarm | Defines if an alarm has to be generated for the given rule |
| Metric | Defines if a metric has to be generated for the given rule |
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 |
/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.8/monitorsguide/hana/hanatables.txt · Last modified: 2023/09/20 16:13 by rbariou
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
