Now, you’ve built up a whole lot of evidence that you can use to write up an overall set of recommendations. We’ll sum up: High-priority health & safety issues that concern you Your SQL Server’s top wait types, and what they mean A high-level list of options including query tuning, index tuning, or throw hardware…
09 Recap and Writing Up Your Findings
Now, you’ve built up a whole lot of evidence that you can use to write up an overall set of recommendations. We’ll sum up: High-priority health & safety issues that concern you Your SQL Server’s top wait types, and what they mean A high-level list of options including query tuning, index tuning, or throw hardware...
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.
- 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
- 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