Autoplay
Autocomplete
Previous Lecture
Complete and Continue
Mastering Parameter Sniffing
Before the Class
Prerequisites
Introductions and Overview (6:19)
Download the Slide Deck and Demo Scripts
Reducing the Stench of Sniffing Problems
With Index Tuning (37:06)
With Query Hints (39:10)
With Recompile Hints (23:34)
Lab 1 Setup: Get One Plan to Work Well Enough for Most (4:56)
Lab 1: Brent's Solution (39:13)
Caching Multiple Plans with Branching
Bad Branching Causes Sniffing, Good Branching Reduces It (24:55)
Lab 2 Setup: Fix a Parameter Sniffing Problem with Branching (2:24)
Lab 2: Brent's Solution (34:20)
Monitoring Sniffing Problems with the Plan Cache
Spotting Variable Plans in the Cache (29:42)
Trending the Plan Cache Over Time (30:49)
Lab 3 Setup: Track Down Sniffing in Plan Cache History (10:14)
Lab 3: Brent's Solution (31:37)
Monitoring Sniffing Problems with Query Store
Lower-Impact Query Store: usp_PlanCacheAutopilot (10:46)
Higher-Impact: Query Store (29:36)
Lab 4 Setup: Track Down Sniffing with Query Store or usp_PlanCacheAutopilot (2:27)
Lab 4: Brent's Solution (28:58)
How SQL Server 2019 Tries to Reduce the Blast Radius
Memory Grant Feedback (31:37)
Adaptive Joins (14:55)
Automatic Tuning, aka Automatic Plan Regression (21:43)
The Final Lab
Lab 5 Setup and Class Recap (4:35)
Working on usp_SearchPostsByPostType (38:53)
Working on usp_RptFastestAnswers (34:56)
Working on usp_SearchPostsByLocation (40:23)
Working on usp_RptQuestionsAnsweredForUser (18:13)
Working on usp_SearchUsers (49:59)
Automatic Tuning, aka Automatic Plan Regression
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock