(DI-2211) 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 | HANA Memory DB global allocation limit | GB | No |
HDB_MEM_CACHE_P | HANA Memory caches used per host | % | No |
HDB_MEM_CS_P | HANA Memory used by column store per host | % | No |
HDB_MEM_HOST_P | HANA Memory physically used per host | % | No |
HDB_MEM_MAX_P | HANA Memory physical max. used (all hosts) | % | No |
HDB_MEM_SQL_P | HANA Memory SQL exec & results used per host | % | No |
HDB_MEM_SQL_P_DB_MAX | HANA Memory SQL exec & results used (max all hosts) | % | No |
HDB_MEM_SRVHOSTD | HANA Memory % of used service memory per host – Delta | % | No |
HDB_MEM_SRVHOSTP | HANA Memory DB used per host | % | No |
HDB_MEM_SRVUSEDP | HANA Memory DB used max. (all hosts) | % | No |
HDB_MEM_STAT_P | HANA Memory monitoring & statistics used per host | % | No |
HDB_MEM_STAT_P_DB_MAX | HANA Memory monitoring & statistics used (max all hosts) | % | No |
HDB_MEM_STMT_ACTIVE_CNT | HANA Number of currently active statements | Count | No |
HDB_MEM_STMT_ACTIVE_USED_MEM | HANA Used memory by currently active statements | MB | No |
HDB_MEM_STMT_OOM | HANA Number of statements out of memory (OOM) | Count | Yes |
HDB_MEM_SYS_P | HANA Memory system used per host | % | No |
HDB_MEM_SYS_P_DB_MAX | HANA Memory system used (max all hosts) | % | No |
HDB_MEM_TOTAL | HANA Memory physical total on HANA available | GB | No |
HDB_MEM_USED | HANA Memory Instance Allocated (total) | GB | No |
HDB_MEM_USED_DB | HANA Memory Instance Used (total) | GB | No |
HDB_MEM_USED_P | HANA Memory DB 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. |
Detail table
The collector provides a detail table for HANA Statements Out of Memory Events. The technical name of the detail table is /DVD/MON_HDB_S_STMT_OOM.
This detail table provides a history for out-of-memory events included in HANA view M_OUT_OF_MEMORY_EVENTS including the current statement memory limit and contains the following fields:
Technical name | Description |
|---|---|
TIMESTAMP | When the records are saved into the Detail table |
SID | System ID |
HOST | Host name |
PORT | Port name |
EVT_TIME | Time of the OOM event |
CONNECTION_ID | Connection ID |
STATEMENT_ID | Statement ID |
STATEMENT_HASH | Statement hash |
HEAP_MEMORY_CATEGORY | Allocator name (if Heap memory fails) |
MEMORY_REQUEST_SIZE | Failed memory allocation [bytes] |
MEMORY_USED_SIZE | Current memory allocated [bytes] |
EVENT_REASON | OOM Event reason |
MEMORY_LIMIT_SIZE | Limit size [bytes] |
TRACEFILE_NAME | OOM Trace file name |
STATEMENT | Statement string |