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