Collector for Table size statistics

The technical name of the Collector for Table Size Statistics is /DVD/MON_CL_COL_TAB_SIZE.

This collector 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.

NOTE This function only works for the following central database systems:

HANA
Oracle
Adabas/MaxDB
DB6
MS SQL
Note that the table statistics must be updated regularly. You can check the table statistics in transaction DB02.

The default KPIs for total table sizes and index sizes have a detail table assigned to them 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. However, you can define a custom list of tables to be monitored in this input table. When table names are specified in the input table, the collector will only collect the statistics 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	Creation time [automatically filled]

Parameters

The following parameters are used for this collector:

Parameter name	Description
MIN_TABLE_SIZE_THRESHOLD_MB	Specifies the threshold for the minimum table size in MB. Enter a number to collect only tables whose table size is greater than this threshold value. For example, if you enter the value 10, it only collects tables with a table size greater than 10 MB. Default value: <Empty>
TOP_N_TABLES	Specifies how many largest tables are collected. For example, if you enter the value 50, it only collects the 50 largest tables. The maximum threshold is 1,000 tables. Default value: 50
UPDATE_TAB_STATS_ON_DB	Specifies whether the table statistics at the database level are calculated automatically during the collector execution. You can enable the calculation of table statistics by setting this value to X. If the field is empty, table statistics are not calculated at the database level. Default value: <Empty>

Parameter name

Description

MIN_TABLE_SIZE_THRESHOLD_MB

Specifies the threshold for the minimum table size in MB.

Enter a number to collect only tables whose table size is greater than this threshold value. For example, if you enter the value 10, it only collects tables with a table size greater than 10 MB.

Default value: <Empty>

TOP_N_TABLES

Specifies how many largest tables are collected. For example, if you enter the value 50, it only collects the 50 largest tables. The maximum threshold is 1,000 tables.

Default value: 50

UPDATE_TAB_STATS_ON_DB

Specifies whether the table statistics at the database level are calculated automatically during the collector execution.

You can enable the calculation of table statistics by setting this value to X. If the field is empty, table statistics are not calculated at the database level.

Default value: <Empty>

Detail Table

The collector provides the detail table DB table size statistics. The technical name of the detail table is /DVD/MON_T_TAB_SIZE_DETAIL.

The detail table DB table size statistics provides detailed information about every collected table. It contains the following fields:

Technical name	Description
TIMESTAMP	Time when the records are saved to the detail table
SID	System ID
TABNAME	Table name
TOTAL_SIZE_MB	Total size (table size + index size) in MB
TAB_SIZE_MB	Table size in MB
INDEX_SIZE_MB	Index size in MB
ROWS	Rows
DDTEXT	Short description of the table