SQL Server blocking occurs when one connection places a lock on a table (or selected rows, pages, extent) and another connection attempts to read or modify the data when the lock is in effect. Another connection has to wait until the resources are released from the original connection which is holding the lock on the resources. Blocking often happens on the server when the system is under heavy transactional workload on a single resource.

The way to resolve blocking is to identify the blocking statements which will then allow optimization of the blocking statements (re-write T-SQL, Indexing, or other configuration changes).

Thanks for reading this article,

Next steps :

1.  Share this with your colleagues because Sharing  is Learning

       2.  Comment below if you need any assistance

Powered by CodeReview – Let’s make it Better!