Summary
By upgrading to SQL Server 2022, you can utilize the many performance enhancements introduced into Intelligent Query Processing (IQP). By utilizing memory grant feedback, you're improving query performance automatically by persisting feedback to the Query Store. Parameter Sensitive Plan solves parameter sniffing with no code changes, and improves performance and scalability with your queries. Degree of Parallelism feedback helps users find the parallel efficiency of queries, while lowering the CPU resources utilized for the query and improves query performance, without any user action needed.
In this module, you've learned to:
- Understand the key functionality behind Intelligent Query Processing and when to implement the feature
- Understand Automatic performance healing with memory grant feedback persistence
- Know how to get consistent performance with Parameter Sensitive Plan optimization
- Gain parallel efficiency with DOP Feedback
Learn more
Use the following resources to learn more about SQL Server 2022:
- Keep up with all the latest on SQL Server 2022
- Get all the details about SQL Server 2022 in the official documentation
- Download and try out SQL Server 2022
- Read details about SQL Server 2022 new features from the engineering team blog
- Get more materials from the self-paced or instructor led SQL Server 2022 workshop