SQL Server 2022 - Parameter Sensitive Plan Optimization and Memory Grant Feedback

This is a quick look at two of the Intelligent Query Processing features in SQL Server 2022: Parameter Sensitive Plan Optimization and Memory Grant Feedback. This is a quick introduction to seeing them in action and understanding how we can use that to help tune our queries long term. If you're trying to understand how these work, take some time to look into these more: Parameter Sensitive Plan Optimization: https://learn.microsoft.com/en-us/sql/relational-databases/performance/parameter-sensitive-plan-optimization?view=sql-server-ver16 Memory Grant Feedback: https://learn.microsoft.com/en-us/sql/relational-databases/performance/intelligent-query-processing-memory-grant-feedback?view=sql-server-ver16#percentile-and-persistence-mode-memory-grant-feedback Microsoft Learn Module: Understand the built-in query intelligence enhancements of SQL Server 2022: https://learn.microsoft.com/en-us/training/modules/sql-server-2022-performance-enhancements/?source=recommendations #sqlserver #sqlserver2022 #pspo #memorygrantfeedback