====== 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 ===== * 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 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 memory|The alarm threshold of the current memory used by all process (HANA and others). You can use the advanced threshold syntax.| ^Max database resident memory|The alarm threshold of the current memory used by HANA system. You can use the advanced threshold syntax.| ^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|