(DI-2305) Collector for HANA Heap memory
- SNP
This collector collects Heap memory details of the HANA database server. There are few predefined KPIs with memory info but additional KPIs can be defined and then mapped through the collector's input table. The collector is selecting either exclusive size in use or inclusive size in use from the M_HEAP_MEMORY view. You are mapping categories to your custom KPIs which are then reported. The technical name of the collector is /DVD/MON_HDB_CL_COL_HEAPMEM.
Default KPIs delivered with this collector
The following default KPIs are delivered with this collector:
KPI name | Description | Unit | Detail table |
|---|---|---|---|
HDB_HEAPCSTABLH | HANA Heap Category: Pool/ColumnStoreTables | MB | No |
HDB_HEAPCSTABLH_MAX | HANA Heap Category: Pool/ColumnStoreTables (max all hosts) | MB | No |
HDB_HEAPDEFLPAH | HANA Heap Category: Pool/PersistenceManager/PersistentSpace/ | MB | No |
HDB_HEAPFLA_ULH | HANA Heap Category: MemoryMapLevel3Nodes | MB | No |
HDB_HEAPITABH | HANA Heap category: Pool/itab | MB | No |
HDB_HEAPPERSMAH | HANA Heap category: Pool/PersistenceManager | MB | No |
HDB_HEAPPERSMAH_MAX | HANA Heap category: Pool/PersistenceManager (max all hosts) | MB | No |
HDB_HEAPPERUTCH | HANA Heap Category: Pool/PersistenceManager/UnifiedTableCont | MB | No |
HDB_HEAPROWENGH | HANA Heap Category: Pool/RowEngine | MB | No |
HDB_HEAPROWENGH_MAX | HANA Heap Category: Pool/RowEngine (max all hosts) | MB | No |
HDB_HEAPSTATSH | HANA Heap Category: Pool/Statistics | MB | No |
HDB_HEAPSTATSH_MAX | HANA Heap Category: Pool/Statistics (max all hosts) | MB | No |
HDB_HEAPTMPQUE | HANA Heap temporary memory used (all hosts) | MB | No |
HDB_HEAPTMPQUEH | HANA Heap temporary memory used (host) | MB | No |
Custom KPIs
The Collector for Heap HANA Memory enables you to create custom KPIs based on this collector. For more information on how to create a custom KPI, see the chapter Create a KPI through the Collectors with a Custom KPI.
After KPI creation you can map it to a custom memory metric using the input table. Data are selected from database view m_heap_memory. You can define if you want to select inclusive_size_in_use or exclusive_size_in_use in the input table. If you are unsure about memory categories, you can use this select statement to get them all:
SELECT DISTINCT category FROM m_heap_memory
Input table
/DVD/MON_HDBHEAP
The rules define which KPI is mapped to certain HANA Heap memory metrics. A collector comes with predefined table inputs that start with HDB* and are already monitored. If you created your own KPI, here you can map it so it selects data under specified categories.
Technical name | Column name | Description |
|---|---|---|
KPI | KPI name | If you created a custom KPI to be mapped to metric, fill its technical name here (Z*/Y*) |
CATEGORY | HANA Heap category | Name of the category from which size in use is selected. Single KPI can have multiple rows with different categories and the total size in use will be aggregated from these categories. |
FIELD | HANA Heap field Inclusive/Exclusive | Sets HANA Heap field I - Inclusive E - Exclusive |
CREATED_BY | Created By User | Changelog |
CREATED_AT | Created At [TIMESTAMP] | Changelog |
CHANGED_BY | Last Changed By User | Changelog |
CHANGED_AT | Last Changed At [TIMESTAMP] | Changelog |