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.



IDERAProductsPurchase | Support | Community | Resources | About Us | Legal