1.3.6 Increase in the number of locks
The increase in the number of locks affects the performance of the Microsoft SQL Server. To monitor the increase in the number of locks, use the Blocked Sessions alarm in the monitoring template which PFM - RM for Microsoft SQL Server provides. The Blocked Sessions alarm monitors the number of sessions that are waiting for lock release by other sessions.
The following table explains the Blocked Sessions alarm in the monitoring template:
Alarm name |
Record used |
Field used |
Abnormal condition |
Warning condition |
Values measured |
---|---|---|---|---|---|
Blocked Sessions |
PD |
Blocked Processes |
Blocked Processes > 2 |
Blocked Processes > 0 |
The sessions that set the locks can be running. |
- Diagnosis:
-
If the value of the Blocked Sessions alarm exceeds 2, the sessions that set the locks can be running.
- Prescription:
-
Check the active sessions connecting to the Microsoft SQL Server.
For details about the Blocked Sessions alarm, see Blocked Sessions in 4. Monitoring Template.