What is blocking in SQL Server?

 Posted by Poster on 6/17/2009 | Category: Sql Server Interview questions | Views: 10675
Answer:

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. For more details on SQL Server blocking visit this nice article
http://www.sql-server-performance.com/tips/blocking_p1.aspx


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response