Blocking
happens when one connection from an application holds a
lock and a second connection requires a conflicting lock
type. This forces the second connection to wait, blocked
on the first.
Read up the following topics in SQL Server books online: Understanding and avoiding blocking, Coding efficient transactions.
Read up the following topics in SQL Server books online: Understanding and avoiding blocking, Coding efficient transactions.
No comments:
Post a Comment