Locking and blocking are fundamental to any database to maintain consistency. In this paper we will look at the various ways to identify potential problems of locking and blocking, how they are different and what options SQL Server gives to resolve them.




Blocking and Locking Troubleshooting