Before touching queries, Brent starts by running sp_BlitzIndex to analyze indexes fast, making a quick series of improvements for this specific workload. Then he switches over to finding the most problematic queries for his current wait stats, then goes back to index tuning for one round of cleanups for a multi-purpose query.
2.5 Lab 4 Solution: Watch Brent Work Through It (84m)
Before touching queries, Brent starts by running sp_BlitzIndex to analyze indexes fast, making a quick series of improvements for this specific workload. Then he switches over to finding the most problematic queries for his current wait stats, then goes back to index tuning for one round of cleanups for a multi-purpose query.
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.3 Lab 1 Solution: Watch Brent Work Through It (51m)
- 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.6 Lab 4 Recap: Slides (9m)