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….
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 Recorded Class Season Pass or How I Use the First Responder Kit, or log in if you already shelled out the cash.
- 00 Prerequisites Before the Class
- 01 Doing a Server-Wide Health Check with sp_Blitz
- 02 Doing a Server-Wide Performance Check with sp_BlitzFirst
- 04 Using sp_BlitzIndex to Diagnose the Most Urgent Index Issues
- 05 Analyzing Deadlocks with sp_BlitzLock
- 06 Check Which Queries Are Running with sp_BlitzWho and sp_WhoIsActive
- 07 Check Your Data Risks with sp_BlitzBackup
- 08 Automate the Data-Gathering Process with the Consultant Toolkit
- 09 Recap and Writing Up Your Findings