SQL Server 2022 has lot of improved and advanced features compared to its predecessor versions. This includes new Server roles, improved Query Store, TempDB performance, Intelligent Query Processing, Contained Availability Groups, Database Ledger, etc.
In today’s article we will see a practical demonstration of once such feature – Parameter Sensitive Plan Optimization(PSPO). We will see the challenges of parameterized stored procedures in older versions and how PSP optimization addresses the challenges and improves query execution plans in this new version.
This article only covers the practical demonstration using a sample database. Please refer to the official documentation from Microsoft to