Parameter Sensitive Plan Optimization and Query Store

Jared Poche

Parameter Sensitive Plan optimization is a new feature in SQL Server 2022. This allows up to three plans to be created for a query that is susceptible to parameter sniffing and makes some changes to Query Store catalog views.

In this session, we’ll review the feature and the changes it brings to Query Store. We’ll look at examples of dispatcher plans and query variant plans, and review the changes needed to make your queries run correctly in SQL Server 2022.