HANA connections

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

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
Connection statusConnection status
UserIf different than star (‘*’), only the connections of the given user will be taken into account
Max ConnectionThe threshold of the connection alarm. If set to 0, the size won’t be monitored
AggregateDefines how the connections are aggregated before comparing them to the threshold (see aggregate mode)
SeverityDefines the level of severity of the alarm that will be generated if one of the thresholds is reached
Auto clearIf set, the generated alarms will be automatically cleared from the console if the alarm condition is not fulfilled anymore
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

CONNECTION_COUNT_PER_USERConnectionsUSERSends the number of connections per user
CONNECTION_COUNTConnectionsHOST or USERSends the total number of connections per host
CONNECTION_RUNNING_COUNTConnectionsHOSTSends the total number of RUNNING connections per host
/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.8/monitorsguide/hana/hanaconnections.txt · Last modified: 2024/03/22 15:58 by rbariou