Whitepaper : Blocking and Locking Troubleshooting


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

Topics :

Products :

Pinal Dave

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

SQL Diagnostic Manager Repository dashboard

24X7 SQL performance monitoring, alerting and diagnostics

  • Monitor performance for physical, virtual, and cloud environments.
  • Monitor queries and query plans to see the causes of blocks and deadlocks.
  • Monitor application transactions with SQL Workload Analysis add-on.
  • View expert recommendations from SQL Doctor to optimize performance.
  • Alert predictively with settings to avoid false alerts.
  • View summary of top issues and alerts with the web console add-on.

Start for Free