(DI-2205) Collector for Table size statistics
The technical name of the Collector for Table size statistics is /DVD/MON_CL_COL_TAB_SIZE.
It collects the top n-largest tables on the system and calculates their total table and index sizes. By default, it collects statistics for the 50 largest tables.
This functionality works only for the following Central database systems:
HANA
Oracle
Adabas/MaxDB
DB6
MsSQL
Please note that Table statistics need to be updated regularly. You might check Table statistics in transaction DB02.
The default KPIs for total table and index sizes have assigned a Detail table that contains further details for each table.
Default KPIs delivered with this collector
The following default KPIs are delivered with this collector:
KPI name | Description | Unit | Detail table |
---|---|---|---|
TOP_INDEX_SIZE_TOTAL | Total index size for top largest tables | MB | Yes |
TOP_TABLE_SIZE_TOTAL | Total table size for top largest tables | MB | Yes |
Input table
The Table size collector has the input table /DVD/MON_TSIZE_I.
By default, this table is empty and the Table size collector loads the n-largest tables on the system, but you might set a custom list of tables to be monitored in this input table. When table names are specified in the input table, the collector will collect the statistics only for these specified tables.
Technical name | Column name | Description |
---|---|---|
TABNAME | Table name | Table Name |
CHANGED_BY | Changed by | Last changed by user [automatically filled] |
CHANGED_BY | Changed by | Last changed by user [automatically filled] |
CREATED_BY | Created by | Created by user [automatically filled] |
CREATED_AT | Created at | Date of creation [automatically filled] |
Parameters
Following parameters are used for this collector:
Parameter name | Description |
---|---|
MIN_TABLE_SIZE_THRESHOLD_MB | Threshold for minimal table size in MB. You might set any number if you want to collects only tables which table size is greater than this threshold value (for example, if you set this value to 10, it will collects only tables with table size greater than 10 MB) Default value: Empty |
TOP_N_TABLES | How many largest tables should be collected? (there is a maximum threshold for 1000 tables) Default: 50 (collects only first 50 largest tables) |
UPDATE_TAB_STATS_ON_DB | Should be the table statistics on DB level calculated automatically during the collector’s execution? You might enable the calculation of table statistics by setting this value to 'X'. Default value: Empty (table statistics are not calculated on DB level) |
Detail table
The collector provides detailed table Details for Table size statistics. The technical name of the detail table is /DVD/MON_T_TAB_SIZE_DETAIL
Details for Table size statistics provide a detailed output for each collected table and contains the following fields:
Technical name | Description |
---|---|
TIMESTAMP | When the records are saved into the Detail table |
SID | System ID |
TABNAME | Table name |
TOTAL_SIZE_MB | Total size (Table + Index size) [MB] |
TAB_SIZE_MB | Table size [MB] |
INDEX_SIZE_MB | Index size [MB] |
ROWS | Rows |
DDTEXT | Short description of the table |