Blocking and locking inside SQL Server are fundamental to maintain consistency. It is important to maintain integrity of data and show consistent data to users accessing the system. SQL Server uses locks on data to prevent data corruption and stop multiple users from updating the same record at the same time. In this paper we will look at:
Various ways to identify potential problems of locking and blocking
How they are different
What options SQL Server gives to identify and resolve them
Pinal Dave is a Developer Evangelist. He has authored 11 SQL Server database books, 14 Pluralsight courses and over 2900 articles on the database technology on his blog at http://blog.sqlauthority.com. Along with 10+ years of hands-on experience, he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). His past work experiences include Technology Evangelist at Microsoft and Sr. Consultant at SolidQ.
Try SQL Diagnostic Manager for SQL Server FREE for 14 days
24X7 SQL performance monitoring, alerting and diagnostics