Intelligent Query Processing in SQL Server 2022 by Edward Pollack

Improve Query Performance with Intelligent Query Processing in SQL Server 2022
About this Event

Abstract

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

SQL Server 2022 debuted 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 use it, and demonstrate how it works. This is intended to provide the information needed to take full advantage of IQP when adopting SQL Server 2022.

As SQL Server evolves, the need to incorporate runtime metrics into execution plans will continue to grow. Taking advantage of Intelligent Query Processing in your current SQL Server versions will allow for easy adoption of new query processing enhancements in future versions.

Speaker Bio

Ed Pollack is a Microsoft Data Platform MVP with a passion for learning how the Microsoft Data Platform works and sharing that knowledge with the community. His experiences in data architecture, database design, performance optimization, and data security are motivation for public speaking, writing, coding, and other community activities. Ed has spoken at SQL Saturday events, SQL Bits, PASS Summit, EightKB, and many other regional and international events. Ed is organizing the Capital Area SQL Server Group and SQL Saturday Albany, as well as a co-organizer of SQL Saturday New York City, and Future Data Driven. He has published several books, including "Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server", "Expert Performance Indexing in Azure SQL and SQL Server 2022", and "Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads". Ed is also an active contributor of content to SimpleTalk. In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.