sp_BlitzLock Archives - Brent Ozar Unlimited®

How to Troubleshoot Blocking and Deadlocking with Scripts and Tools

November 28, 2018

When you need to find which queries are blocking other queries, your decision comes down to when the blocking happened. Is it happening now, recently, or coming up soon? During a live emergency, start with sp_WhoIsActive. Adam Machanic's excellent free sp_WhoIsActive replaces Activity Monitor, sp_who, and sp_who2, and it's way more powerful. The documentation is extensive -…

Introducing sp_BlitzLock: For Troubleshooting SQL Server Deadlocks

December 19, 2017

Deadlocks are hard - especially when there are a lot of them. When there are dozens or more, looking at each graph is a pain.

sp_BlitzLock gives you a slice-and-dice analysis of which tables, indexes, and queries are involved in most of your deadlocks so you can quickly get to the root cause.