Brent starts the Lab 1 workload, then steps through a quick SQL Server health check with sp_Blitz, then captures wait stats details with sp_BlitzFirst @ExpertMode = 1, @Seconds = 60. From there, he runs sp_BlitzIndex to check the server’s index designs, and sp_BlitzCache to check which queries were causing the top wait types. He finishes…
1.3 Lab 1 Solution: Watch Brent Work Through It (51m)
Brent starts the Lab 1 workload, then steps through a quick SQL Server health check with sp_Blitz, then captures wait stats details with sp_BlitzFirst @ExpertMode = 1, @Seconds = 60. From there, he runs sp_BlitzIndex to check the server’s index designs, and sp_BlitzCache to check which queries were causing the top wait types. He finishes…
You'll need a membership to access this course. Check out my training classes.
- 1.1 Introduction to Your Lab Server and Lab #1 (37m)
- 1.2 Lab 1 Solution: What We’re Looking For (3m)
- 1.4 Lab 2 Introduction: Fix It with Indexes (3m)
- 1.5 Lab 2 Solution: What We’re Looking For (8m)
- 1.6 Lab 2 Solution: Watch Brent Work Through It (60m)
- 2.1 Lab 3 Introduction: Fix It with Code Changes (11m)
- 2.2 Lab 3 Solution: Watch Brent Work Through It (55m)
- 2.3 Lab 3 Recap: Slides (7m)
- 2.4 Lab 4 Introduction: Fix Everything! (5m)
- 2.5 Lab 4 Solution: Watch Brent Work Through It (84m)
- 2.6 Lab 4 Recap: Slides (9m)