Hi
I use SCOM 2012 and
System Center Monitoring pack for SQL Server
I need use:
Blocking Sessions Monitor
This monitor checks blocking sessions every 300 seconds (Interval). If there is a blocking session that is blocked more than 1 minute (wait time) and the amount of such blocking sessions is more or equal to 1 (Number of blocked session),
then the monitor changes state to Critical.
The following parameters are overridable.
|
Parameter
|
Default value
|
|
Alert On State
|
Critical
|
|
Alert Priority
|
High
|
|
Alert Severity
|
Critical
|
|
Auto-Resolve Alert
|
True
|
|
Generates Alert
|
True
|
|
Enabled
|
False
|
|
Interval (sec)
|
300
|
|
Number of blocked sessions
|
1
|
|
Wait Time (min)
|
1
|
|
Synchronization Time
|
|
|
Timeout (sec)
|
300
|
How to change Wait Time (min) to Wait Time (sec)?
I can not change the value Wait Time (min) from 1 to
0.1, because the value type Integer ((
