What is Blocking in SQL Server ?

SQL Server blocking occurs when one connection places a lock on a table (or selected rows, pages, extend) and another connection attempts to read or modify the data when the lock is in effect. Another connection has to wait till the resources are released from the original connection which is holding a lock on resources.

Often blocking happens on the server where the system is under heavy transactional workload on a single resource. The way to resolve the blocking is to identify the statement which is creating blocking and optimize them (re write T-SQL, Indexing, other configuration changes).



You May Interest

What is the XML Datatype in SQL Server ?

What are the Limitations of Indexed Views in SQL Server ?

What is Auditing Inside SQL Server ?

Using MS SQL If Else

What is the Filtered Index in SQL Server ?