1
Reply

What is blocking and how would you troubleshoot it?

Arvind Yadav

Arvind Yadav

3y
1.6k
1
Reply

What is blocking and how would you troubleshoot it?

    Blocking occurs when two or more rows are locked by one SQL connection and a second connection to the SQL server requires a conflicting on lock on those rows. This results in the second connection to wait until the first lock is released. - The common blocking scenarios must be identified and resolved