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 nameRecord usedField usedAbnormal conditionWarning conditionValues measured
Blocked SessionsPDBlocked ProcessesBlocked Processes > 2Blocked Processes > 0The 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.