Blocked Sessions
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 | Product | RM SQLServer |
Message text | %CVS session(s) are blocked | |
Enable alarm | Selected | |
Evaluate all data | Not selected | |
Monitoring time range | Always | |
Alarm when damping conditions are satisfied | Not selected | |
Interval | -- | |
Maximum occurrences | -- | |
Actions | -- | |
Command | -- | |
SNMP | Abnormal, Warning, Normal | |
Conditional Expressions | Record | Server Detail (PD) |
Field | Blocked Processes | |
Abnormal condition | Blocked Processes > 2 | |
Warning condition | Blocked Processes > 0 |
Related report
Reports/RM SQLServer/Troubleshooting/Real-Time/Blocking Locks