==== HANA threads ==== === Purpose === Operations executed on the database occur within working threads. A long running thread can potentially indicate performance or optimization issues. This monitor will look for running threads and notify when a threads runs for too long === Configuration hints === You can define a max runtime threshold in order to be notified if a thread is running for too long You can specify different thresholds per service === 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|Filters threads from a given service. A star (‘*’) will match any service| ^Max duration (ms)|The threshold for the long running threads alarm| ^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^ |THREADS_COUNT|Threads|HOST|Returns the number of running threads|