03 Using sp_BlitzCache to Find the Queries Causing Your Top Waits
If I could only pick one script in the First Responder Kit to use for the rest of my life, it would probably be sp_BlitzCache. You could just run it as-is with no parameters and learn a lot, but it’s even better now that you’re armed with an understanding of your server’s top wait types….
