Understand the built-in query intelligence enhancements of SQL Server 2022
Learn about and use the Intelligent Query Processing feature enhancements in SQL Server 2022.
Learning objectives
At the end of this module, you'll be able 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
Prerequisites
- Basic working knowledge of SQL Server and query processing.
- Fundamental knowledge of the T-SQL language.
- Installed SQL Server 2022.