Pro.Monitor V6.7
Trouble shooting
Monitors Guide
Sidebar
products:promonitor:6.7:monitorsguide:hana:hanathreads
Book Creator
Add this page to your book
Add this page to your book Book Creator
Remove this page from your book
Remove this page from your book 
Manage book (
Help Table of Contents
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 |
/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.7/monitorsguide/hana/hanathreads.txt · Last modified: 2019/02/11 15:26 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
