Malta Query Optimization: Query Performance with Intelligent Query Processing in SQL Server 2022

Intelligent Query Processing (IQP) allows SQL Server to make dynamic, smarter decisions at runtime when processing queries. What’s more, these features are on by default when SQL Server is upgraded to a compatible version! Even better, each version of SQL Server adds more features to this suite of performance enhancements.

SQL Server 2022 adds many new features to Intelligent Query Processing, including:
Cardinality Estimation Feedback
Degree of Parallelism Feedback
Approximate Percentile Calculations
Feedback Persistence
Parameter Sensitive Plan Optimization
Optimization Replay

This session will dive into each new feature, how to make use of it, and demonstrating how it works. This is intended to provide the information needed to take full advantage of IQP when adopting SQL Server 2022.

[DennesTorres]

Reference links offered during the conference:

MSC and SQL Server 2022

Synapse Link on Data Exposed

Ledger and Lenovo

Synapse Link for SQL

Failover to Managed Instances

SQL Ledger

Bob Ward Github with many samples about IQP and much more