Blocking in SQL server

Question

Hi Friends I want to know about blocking and how can I you troubleshoot it ?

Satyapriya Nayak · Answer

Hi Manish Blocking in SQL Server is a scenario where one connection to SQL Server locks one or more records and a second connection to SQL Server requires a conflicting lock type on the record or records locked by the first connection. This causes the second connection to wait until the first connection releases its locks. By default a connection will wait an unlimited amount of time for the blocking lock to go away.Blocking is not the same thing as a deadlock. Please refer the below links http://www.sql-server-performance.com/tips/blocking_p1.aspx Normal 0 http://www.mssqltips.com/sqlservertip/1978/understanding-sql-server-blocking/ Thanks

Sukesh Marla · Answer

You might want to know about Locking Check this link http://www.sqlteam.com/article/introduction-to-locking-in-sql-server Check this is correct answer if it helped