Articles tagged sql server locking blocking database administration tacklebox

31 July 2009
31 July 2009

The DBA as Detective: Troubleshooting Locking and Blocking

In this article, taken from Chapter 5 of his great new book, SQL Server Tacklebox, Rodney describes in his own unique style how he, as a working DBA, goes about troubleshooting problem queries, and investigating various types of locking and blocking problems. In the process, he  passes on valuable tips learned from practical, and sometimes stressful, experience.… Read more