What is blocking in SQL Server?

 Posted by Poster on 6/17/2009 | Category: Sql Server Interview questions | Views: 12367
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

Posted by: NEERAJPRASADSHARMA on: 1/14/2019 | Points: 10
This a incorrect, not record yes, it may be "Row/s", but it's actually resources, it may be IO, CPU, Resources related blockage.

Login to post response