I know, I know, the name sp_BlitzFirst sounds like it should be the first query that I would run – and it is, when I’m doing emergency performance troubleshooting. That’s not what we’re doing here, though. Here, we’re using it as part of a bigger process to check our server’s wait stats. I’ll talk about…
02 Doing a Server-Wide Performance Check with sp_BlitzFirst
I know, I know, the name sp_BlitzFirst sounds like it should be the first query that I would run – and it is, when I’m doing emergency performance troubleshooting. That’s not what we’re doing here, though. Here, we’re using it as part of a bigger process to check our server’s wait stats. I’ll talk about...
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
- 03 Using sp_BlitzCache to Find the Queries Causing Your Top Waits
- 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