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….

To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Recorded Class Season Pass or How I Use the First Responder Kit, or log in if you already shelled out the cash.

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....
To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Recorded Class Season Pass or How I Use the First Responder Kit, or log in if you already shelled out the cash.
Menu
{"cart_token":"","hash":"","cart_data":""}