(DI-2305) Collector for HANA Memory Usage

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

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

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

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