Hi Friends
I want to know about blocking and how can I you troubleshoot it ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Sep 11, 2012, 10:39 AM
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
http://www.mssqltips.com/sqlservertip/1978/understanding-sql-server-blocking/
Thanks
Sukesh MarlaPosted Sep 11, 2012, 8:08 AM
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