Autoplay
Autocomplete
Speed
Previous Lecture
Complete and Continue
Mastering Parameter Sniffing
Before the Class
Prerequisites
Introductions and Overview (9:38)
Download the Slide Deck
Reducing the Blast Radius of Sniffing Problems
With Index Tuning (33:31)
With Query Hints (38:34)
With Recompile Hints (27:54)
Lab 1 Setup: Get One Plan to Work Well Enough for Most (3:30)
Lab 1: Brent's Solution (38:35)
Caching Multiple Plans with Branching
Bad Branching Causes Sniffing, Good Branching Reduces It (32:43)
Lab 2 Setup: Fix a Parameter Sniffing Problem with Branching (3:36)
Lab 2: Brent's Solution (44:29)
Monitoring Sniffing Problems with the Plan Cache
Spotting Variable Plans in the Cache (33:00)
Trending the Plan Cache Over Time (37:32)
Lab 3 Setup: Track Down Sniffing in Plan Cache History (10:56)
Lab 3: Brent's Solution (34:12)
Monitoring Sniffing Problems with Query Store
Lower-Impact Query Store: usp_PlanCacheAutopilot (16:40)
Higher-Impact: Query Store (36:29)
Lab 4 Setup: Track Down Sniffing with Query Store or usp_PlanCacheAutopilot (2:51)
Lab 4: Brent's Solution (25:16)
How SQL Server 2019 Tries to Reduce the Blast Radius
Memory Grant Feedback (37:59)
Adaptive Joins (19:37)
Automatic Tuning, aka Automatic Plan Regression (19:00)
The Final Lab
Lab 5 Setup and Class Recap (4:35)
Working on usp_SearchPostsByPostType (38:53)
Working on usp_RptFastestAnswers (88:00)
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