What is blocking and how would you troubleshoot it?
Arvind Yadav
Select an image from your device to upload
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