Exploring Intelligent Query Processing (IQP) Features in SQL Server 2022

SQL Server 2022 introduces advanced Intelligent Query Processing (IQP) capabilities that redefine how queries are optimized and executed. These features enhance performance, minimize query-tuning efforts, and improve database efficiency. In this presentation, we will explore the key IQP features of SQL Server 2022, their practical applications, and their impact on real-world workloads.

This demo-centric session will cover-
- Overview of IQP Features in SQL Server 2022
- Parameter Sensitive Plan (PSP) Optimization
- Query Store Advancements
- Feedback-based Query Processing Enhancements like
- Memory Grant Feedback (Per Query Execution)
- Degree of Parallelism (DOP) Feedback
- Cardinality Feedback
- Feedback Persistence

By the end of this session, the audience will have a deep understanding of how these IQP features can help them run their queries faster.