Collector for HANA Memory Usage
The technical name of the Collector for HANA Memory Usage is /DVD/MON_HDB_CL_COL_MEM.
This collector collects information about the physical memory used by the HANA server.
Default KPIs Delivered with This Collector
The following default KPIs are delivered with this collector:
|
KPI name |
Description |
Unit |
Detail table |
|---|---|---|---|
|
HDB_MEM_ALLOCLIM |
Global memory allocation limit for the database |
GB |
No |
|
HDB_MEM_CACHE_P |
Memory used by caches per host |
% |
No |
|
HDB_MEM_CS_P |
Memory used by column store per host |
% |
No |
|
HDB_MEM_HOST_P |
Physical memory used per host |
% |
No |
|
HDB_MEM_MAX_P |
Maximum physical memory used (all hosts) |
% |
No |
|
HDB_MEM_SQL_P |
Memory used by the SQL execution and the results per host |
% |
No |
|
HDB_MEM_SQL_P_DB_MAX |
Memory used by the SQL execution and the results (max. all hosts) |
% |
No |
|
HDB_MEM_SRVHOSTD |
Percentage of used service memory per host – delta |
% |
No |
|
HDB_MEM_SRVHOSTP |
Database memory used per host |
% |
No |
|
HDB_MEM_SRVUSEDP |
Maximum database memory used (all hosts) |
% |
No |
|
HDB_MEM_STAT_P |
Memory used by the monitoring and the statistics per host |
% |
No |
|
HDB_MEM_STAT_P_DB_MAX |
Memory used by the monitoring and the statistics (max. all hosts) |
% |
No |
|
HDB_MEM_SYS_P |
Memory used by system per host |
% |
No |
|
HDB_MEM_SYS_P_DB_MAX |
Memory used by system (max. all hosts) |
% |
No |
|
HDB_MEM_TOTAL |
Total physical memory available on HANA |
GB |
No |
|
HDB_MEM_USED |
Total physical memory used |
GB |
No |
|
HDB_MEM_USED_DB |
Total memory used by the database |
GB |
No |
|
HDB_MEM_USED_P |
Total database memory used |
% |
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 |
