User Tools

Site Tools


products:promonitor:6.7:monitorsguide:hana:hanathreads

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

ParameterDescription
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
ServiceFilters threads from a given service. A star (‘*’) will match any service
Max duration (ms)The threshold for the long running threads alarm
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

metricIdmetricUnitmetricTargetmetricDescription
THREADS_COUNTThreadsHOSTReturns the number of running threads
/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.7/monitorsguide/hana/hanathreads.txt · Last modified: 2019/02/11 15:26 (external edit)