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 |
SQL(9.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/SQL/Troubleshooting/Real-Time/Blocking Locks (8.0)