LatchMonitor
| Task Type: |
Database Monitor |
| Configurable: |
Yes |
| Host Dependent: |
No |
| Schedule Dependent: |
Yes |
Description
The LatchMonitor monitors the database for excessive latch sleep activity. An alert is generated when latch sleep activity exceeds a configurable threshold.
Configuration
The <LatchMonitorConfig> element is configured with the following attributes:
| Attribute |
Required |
Description |
| SLEEP_THRESHOLD |
Yes |
The LatchMonitor examines only those latches for which the number of sleeps exceeds the value specified for SLEEP_THRESHOLD. The value provided for this attribute must be a positive integer. |
| MAX_SLEEP_RATE |
Yes |
The LatchMonitor generates an alert when the sleep rate (100*sleeps/gets) exceeds the value specified by MAX_SLEEP_RATE for any latch having sleeps in excess of SLEEP_THRESHOLD. The value provided for this attribute must be a positive number. |
| MAX_SLEEP_RATE_CHANGE |
Yes |
The MAX_SLEEP_RATE_CHANGE specifies the maximum allowed change in a latch sleep rate, from one task execution to the next, before an alert is generated. |
Example
<LatchMonitorConfig SLEEP_THRESHOLD="1000"
MAX_SLEEP_RATE="0.1"
MAX_SLEEP_RATE_CHANGE="2.0"/>
In this example, TCAgent sends an alert when any latch with more than 1000 sleeps either has a sleep rate greather than 0.1, or has a sleep rate that has more than doubled (2x) from the prior task execution.
