This week, I’m giving away modules from my How I Use the First Responder Kit class. So far, we covered a server-wide health check with sp_Blitz, then a server-wide performance checkup with sp_BlitzFirst, then using sp_BlitzCache to find the queries causing your bottlenecks, then how to fix indexes for lots of queries at once with sp_BlitzIndex. Today, let’s cover the sorcery known as sp_BlitzLock.
If you bookmark these posts for later reading, just be aware that they’ll self-destruct on May 1 – so keep up. If you can read & watch quickly, you get the benefit of free training. (Worth the