What is blocking in SQL Server?

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

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

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response