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
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