Troubleshooting Blocking in SQL Database–the why

Chris Skorlinski Microsoft SQL Server Escalation Services In my last blog posting I explored SQL DMVs used to find who is blocking queries from running.  By Who, I mean other queries.  We calls these "head blockers".  Our goal is to get those head blockers finished as quickly as possible to release resources for other queries….