What
is blocking in SQL Server
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
Blocking is not the same thing as a deadlock. For more details on SQL Server blocking visit this nice article
No comments:
Post a Comment