Saturday, 10 November 2012

What is blocking and how would you troubleshoot it? | SQL DBA

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.

No comments: