The Blocked Sessions (Count) metric counts the number of sessions on the SQL Server instance blocked by other sessions holding requested locks.

By default, a blocked session waits forever for a lock. You can change this behavior by adding SET LOCKTIMEOUT 60000 to the top of the first T-SQL batch after you make a connection.


SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >