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 ConsoleSetting
ItemDetailed item
MainProductRM SQLServer
Message text%CVS session(s) are blocked
Enable alarmSelected
Evaluate all dataNot selected
Monitoring time rangeAlways
Alarm when damping conditions are satisfiedNot selected
Interval--
Maximum occurrences--
ActionsE-mail--
Command--
SNMPAbnormal, Warning, Normal
Conditional ExpressionsRecordServer Detail (PD)
FieldBlocked Processes
Abnormal conditionBlocked Processes > 2
Warning conditionBlocked Processes > 0
Legend:
--: The setting is always invalid.

Related report

Reports/RM SQLServer/Troubleshooting/Real-Time/Blocking Locks