The Query Processor is one of the most sophisticated components of an RDBMS, and SQL Server is no exception. Sometimes, suboptimal situations can occur; for this reason, starting with the 2017 version, several analysis and self-healing features have been introduced to address performance regression issues, under the umbrella term “Intelligent Query Processing” (IQP). In this session, we will review the features from previous versions and take a detailed look at the many new capabilities introduced with SQL Server 2022.