==== HANA connections ==== === Purpose === The connections are an indicator of the database load and utilization. This monitor will watch for the number of RUNNING connections and send an alarm if too many are detected. === Configuration hints === You can configure it to send an alarm when too many connections are open on a given instance It differentiates RUNNING connections from IDLE connections You can also monitor the connections of a given user or group of users === 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| ^Connection status|Connection status| ^User|If different than star (‘*’), only the connections of the given user will be taken into account| ^Max Connection|The threshold of the connection alarm. If set to 0, the size won’t be monitored| ^Aggregate|Defines how the connections are aggregated before comparing them to the threshold (see aggregate mode)| ^Severity|Defines the level of severity of the alarm that will be generated if one of the thresholds is reached| ^Auto clear|If set, the generated alarms will be automatically cleared from the console if the alarm condition is not fulfilled anymore| ^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^ |CONNECTION_COUNT_PER_USER|Connections|USER|Sends the number of connections per user| |CONNECTION_COUNT|Connections|HOST or USER|Sends the total number of connections per host| |CONNECTION_RUNNING_COUNT|Connections|HOST|Sends the total number of RUNNING connections per host|