(DI-2208) Collector for HANA Memory Usage
- SNP
This collector collects information about physical memory used by the HANA server. The technical name of this collector is /DVD/MON_HDB_CL_COL_MEM
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 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 | Used physical memory per host | % | No |
HDB_MEM_MAX_P | Maximum used physical memory (all hosts) | % | No |
HDB_MEM_SQL_P | Memory used by SQL exec & results per host | % | No |
HDB_MEM_SQL_P_DB_MAX | Memory used by SQL exec & 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 monitoring & statistics per host | % | No |
HDB_MEM_STAT_P_DB_MAX | Memory used by monitoring & 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 on HANA available | GB | No |
HDB_MEM_USED | Total physical memory used | GB | No |
HDB_MEM_USED_DB | Total memory used by 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 | By default off. When 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. |