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 (27:49)
With Query Hints (38:49)
With Recompile Hints (21:54)
Lab 1 Setup: Get One Plan to Work Well Enough for Most (4:52)
Lab 1: Brent's Solution (42:42)
Caching Multiple Plans with Branching
Bad Branching Causes Sniffing, Good Branching Reduces It (27:02)
Lab 2 Setup: Reducing Sniffing by Caching Multiple Plans (3:17)
Lab 2: Brent's Solution (39:05)
Monitoring Sniffing Problems with the Plan Cache
Spotting Variable Plans in the Cache (52:50)
Lower-Impact Query Store: usp_PlanCacheAutopilot (6:55)
Higher-Impact: Query Store (32:53)
Lab 3 Setup: Track Down Sniffing in Plan Cache History (3:57)
Lab 3: Brent's Solution (38:31)
How SQL Server 2019 and 2022 Tries to Reduce the Blast Radius
Memory Grant Feedback (28:45)
Adaptive Joins (15:42)
Automatic Tuning, aka Automatic Plan Regression (21:43)
The Final Lab
Lab 4 Setup and Class Recap (5:57)
Working on usp_SearchPostsByPostType (33:18)
Working on usp_RptFastestAnswers (65:00)
Working on usp_SearchPostsByLocation (40:23)
Working on usp_RptQuestionsAnsweredForUser (18:13)
Working on usp_SearchUsers (49:59)
Working on usp_RptUsersLeaderboard (35:22)
Working on usp_RptPostLeaderboard (37:22)
Working On usp_RptAvgAnswerTimeByTag (24:44)
Lab 3 Setup: Track Down Sniffing in Plan Cache History
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock