Collector for HANA Table Sizes
The technical name of the Collector for HANA Table Sizes is /DVD/MON_HDB_CL_COL_TAB.
This collector reports information about HANA column table sizes, unloads due to low memory and partitions that are too large.
Default KPIs Delivered with This Collector
The following default KPIs are delivered with this collector:
|
KPI name |
Description |
Unit |
Detail table |
|---|---|---|---|
|
HDB_CS_DELRATIO |
Delta memory / Total memory ratio |
% |
No |
|
HDB_CS_DELTASIZE |
Delta memory size |
MB |
No |
|
HDB_CS_ESTIMSIZE |
Estimated size of column tables |
MB |
No |
|
HDB_CS_H_ESTSIZE |
Estimated size of column tables per host |
MB |
No |
|
HDB_CS_H_TOTSIZE |
Total memory size of column tables per host |
MB |
No |
|
HDB_CS_MAINSIZE |
Size of column tables in the main memory |
MB |
No |
|
HDB_CS_TOTALSIZE |
Total memory size of column tables |
MB |
No |
|
HDB_CS_UNLOADS |
Number of unloads |
|
No |
|
HDB_CS_UNLOADS04 |
Number of unloads due to low memory with priority 0 to 4 |
Count |
No |
|
HDB_CS_UNLOADS56 |
Number of unloads due to low memory with priority 5 to 6 |
Count |
No |
|
HDB_CS_UNLOADS79 |
Number of unloads due to low memory with priority 7 to 9 |
Count |
No |
|
HDB_CS_UNLOADSL |
Number of unloads due to low memory |
Count |
No |
|
HDB_PART_CNT_ABX |
Number of partitions above X million rows |
Count |
No |
|
HDB_RS_ALLOC |
Row store allocated size |
MB |
No |
|
HDB_RS_FRAG |
Row store fragmentation |
% |
No |
Parameters
The following parameters are used for this collector:
|
Parameter name |
Description |
|---|---|
|
INCLUDE_PERS_MEMORY_SIZE |
If selected, persistent memory is also taken to account when collecting KPIs. Persistent memory (non-volatile RAM, also referred to as storage class memory) is supported in SAP HANA as a persistent storage type. Default value: Disabled |
|
PART_CNT_ABOVE_ROWS |
This parameter affects the KPI HDB_PART_CNT_ABX. It only reports partitions that have more rows than the number set by this parameter. Default value: 1 billion |
