Blocked Sessions
- Organization of this page
Overview
The Blocked Sessions alarm monitors the number of sessions on the Microsoft SQL Server that are waiting for lock releases by other sessions.
Main settings
|
Alarm properties in PFM - Web Console |
Setting |
|
|---|---|---|
|
Item |
Detailed item |
|
|
Main Information |
Product |
RM SQLServer(7.0) |
|
Alarm message |
%CVS session(s) are blocked |
|
|
Enable alarm |
Selected |
|
|
Alarm notification |
Notify when the state changed |
|
|
Notification target |
State changes for the alarm |
|
|
Evaluate all data |
Not selected |
|
|
Monitoring time range |
Always |
|
|
Report alarm when the following damping condition is reached |
Not selected |
|
|
occurrence(s) during |
-- |
|
|
interval(s) |
-- |
|
|
Alarm Conditions |
Record |
Server Detail (PD) |
|
Field |
Blocked Processes |
|
|
Abnormal condition |
Blocked Processes > 2 |
|
|
Warning condition |
Blocked Processes > 0 |
|
|
Actions |
|
-- |
|
Command |
-- |
|
|
SNMP |
Abnormal, Warning, Normal |
|
- Legend:
-
--: The setting is always invalid.
Related report
Reports/RM SQLServer/Troubleshooting/Real-Time/Blocking Locks (6.0)