![[Contents]](FIGURE/CONTENT.GIF)
Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
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
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.