How SQL Server 2022's Parameter Sensitive Plan Feature Can Make Query Store Confusing скачать в хорошем качестве

How SQL Server 2022's Parameter Sensitive Plan Feature Can Make Query Store Confusing

In this video, I delve into the exciting new parameter-sensitive plan optimization introduced in SQL Server 2022. After a bit of a hiatus from recording videos due to other commitments and personal projects, the release of SQL Server 2022 has reignited my passion for sharing knowledge with you all. The video explores how this feature works by running queries multiple times with different input values, demonstrating the creation of distinct plans based on parameter sensitivity. I also highlight some quirks in query store data handling and plan cache management that arise from this optimization, offering insights into what developers might encounter as they adapt to these changes. 📑 CHAPTERS 1. *Introduction (0:00 - 0:39)* 2. *Parameter Sniffing Issues (0:40 - 1:56)* 3. *Query Store Changes (1:57 - 8:29)* 4. *Identifying Varying Plans (8:30 - 11:27)* 5. *Future Improvements (11:28 - 13:16)* 6. *Conclusion (13:17 - 14:02)* ━━━━━━━━━━━━━━━━━━━━━━━━━━ In this video, I delve into the exciting new parameter-sensitive plan optimization introduced in SQL Server 2022. After a bit of a hiatus from recording videos due to other commitments and personal projects, the release of SQL Server 2022 has reignited my passion for sharing knowledge with you all. The video explores how this feature works by running queries multiple times with different input values, demonstrating the creation of distinct plans based on parameter sensitivity. I also highlight some quirks in query store data handling and plan cache management that arise from this optimization, offering insights into what developers might encounter as they adapt to these changes. 📑 CHAPTERS HH:MM:SS - Chapter Title 00:00:00 - Introduction and Background 00:00:30 - SQL Server 2022 Release and Parameter-Sensitive Plan Optimization 00:01:09 - Overview of Parameter Sniffing Issues in SQL Server 2022 00:01:44 - Demonstration Setup and Query Explanation 00:02:16 - Query Execution and Plan Cache Management 00:02:57 - Understanding Parameter-Sensitive Plans and Bucketized Values 00:03:24 - Analysis of Generated Plans 00:04:19 - Issues with Plan Cache and Stored Procedures 00:04:59 - Query Store Weirdness and Additional Considerations ━━━━━━━━━━━━━━━━━━━━━━━━━━ ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 TRAINING & COURSES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Get AI-Ready With Erik https://training.erikdarling.com/get-... SQL Server Performance Engineering Course https://training.erikdarling.com/sql-... Learn T-SQL with Erik https://training.erikdarling.com/lear... Everything Bundle: https://training.erikdarling.com/?cou... ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🛠️ CONSULTING & SERVICES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Need SQL Server performance help? https://training.erikdarling.com/sqlc... ━━━━━━━━━━━━━━━━━━━━━━━━━━ 💬 CONNECT ━━━━━━━━━━━━━━━━━━━━━━━━━━ Ask questions at Office Hours https://erikdarling.com/officehours/ Become a channel member    / @erikdarlingdata