Pro.Monitor V6.7
Trouble shooting
Monitors Guide
Sidebar
products:promonitor:6.7:monitorsguide:hana:databasememoryutilization
Book Creator
Add this page to your book
Add this page to your book Book Creator
Remove this page from your book
Remove this page from your book 
Manage book (
Help Table of Contents
Database memory utilization
Purpose
Memory is the main resource of HANA DB and must be watched closely. This monitor will check the memory usage of every service and notify if utilization exceeds threshold
Configuration hints
Create a rule in the surveillance table to start monitoring memory usage. Use host and service filter to customize the monitoring for a given node or service
Memory utilization is computed at different levels: - Instance level: The combined usage of all services - Service level: The usage of each individual service It gives the possibility to monitor the current memory consumption as well as an increase of the consumption over a given period of time.
Atomic fields
| Auto clear | If set, the generated alarms will be automatically cleared from the console if the alarm condition is not fulfilled anymore |
|---|
Surveillance table
| Parameter | Description |
|---|---|
| Active | If checked, the rule is enabled and will be processed |
| Host | Can be used to restrict the monitoring to a given host (multi instance case). A star (‘*’) will match any host |
| Service | Defines which service is monitored. A star (‘*’) will match any service, and therefore, it will calculate the combined usage of all services. Otherwise, it is the usage of the specified service that will be calculated |
| Max used memory (Mb/%) | The alarm threshold for the current memory usage. You can specify percentage or absolute value in Mega Bytes |
| Max used memory delta (Mb/%) | The alarm threshold of the memory consumption increase over the period set in the “Delta time” field. Example: Send an alarm if the memory usage increases by 20% in the last 5 min |
| Max total resident memory | The alarm threshold of the current memory used by all process (HANA and others). |
| Max database resident memory | The alarm threshold of the current memory used by HANA system. |
| Delta time | The period of time used to make a delta comparison of the memory usage |
| Severity | Defines the level of severity of the alarm that will be generated if one of the thresholds is reached |
| Alarm tag | You can define some text to use as a prefix of the alarm message generated by the current rule |
| Alarm | Defines if an alarm has to be generated for the given rule |
| Metric | Defines if a metric has to be generated for the given rule |
Generated metrics
| metricId | metricUnit | metricTarget | metricDescription |
|---|---|---|---|
| MEMORY_PERCENTAGEUSED | Percent or Mega Bytes | HOST | Sends memory usage ratio per host |
| MEMORY_USED | Percent or Mega Bytes | HOST - SERVICE | Sends memory used space |
| MEMORY_PERCENTAGEUSED_PER_SERVICE | Percent or Mega Bytes | HOST - SERVICE | Sends memory usage ratio per service |
| MEMORY_USED_PER_SERVICE | Percent or Mega Bytes | HOST - SERVICE | Sends memory used space per service |
| MEMORY_ALLOC_SIZE | Mega Bytes | HOST - SERVICE | Sends memory allocation size per service |
| MEMORY_EFFECTIVE_ALLOC_SIZE | Mega Bytes | HOST - SERVICE | Sends effective memory allocation size per service |
/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.7/monitorsguide/hana/databasememoryutilization.txt · Last modified: 2019/02/11 15:26 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
