Table of Contents

Database memory utilization

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

Memory utilization is computed at different levels:

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

ParameterDescription
ActiveIf checked, the rule is enabled and will be processed
HostCan be used to restrict the monitoring to a given host (multi instance case). A star (‘*’) will match any host
ServiceDefines 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 GB and use the advanced threshold syntax.
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 memoryThe alarm threshold of the current memory used by all process (HANA and others). You can use the advanced threshold syntax.
Max database resident memoryThe alarm threshold of the current memory used by HANA system. You can use the advanced threshold syntax.
Delta timeThe period of time used to make a delta comparison of the memory usage
SeverityDefines the level of severity of the alarm that will be generated if one of the thresholds is reached
Alarm tagYou can define some text to use as a prefix of the alarm message generated by the current rule
AlarmDefines if an alarm has to be generated for the given rule
MetricDefines if a metric has to be generated for the given rule

Generated metrics

metricIdmetricUnitmetricTargetmetricDescription
MEMORY_PERCENTAGEUSEDPercent or Mega BytesHOSTSends memory usage ratio per host
MEMORY_USEDPercent or Mega BytesHOST - SERVICESends memory used space
MEMORY_PERCENTAGEUSED_PER_SERVICEPercent or Mega BytesHOST - SERVICESends memory usage ratio per service
MEMORY_USED_PER_SERVICEPercent or Mega BytesHOST - SERVICESends memory used space per service
MEMORY_ALLOC_SIZEMega BytesHOST - SERVICESends memory allocation size per service
MEMORY_EFFECTIVE_ALLOC_SIZEMega BytesHOST - SERVICESends effective memory allocation size per service