Session

How Intelligent Query Processing (IQP) can help reduce cloud costs

As organizations continue moving SQL Server workloads to Azure, inefficient query processing no longer impacts only performance. It directly affects cloud spending. Higher CPU utilization, larger memory grants, and unnecessary scaling all increase operational costs.

Intelligent Query Processing (IQP) introduced a new generation of optimizer enhancements that enable SQL Server and Azure SQL to automatically improve query performance, frequently without requiring application changes.

In this hands-on workshop, you'll learn how SQL Server identifies performance bottlenecks and how IQP features such as Batch Mode on Rowstore, Adaptive Joins, Memory Grant Feedback, Scalar UDF Inlining, and Table Variable Deferred Compilation help reduce resource consumption while improving workload stability.

Using practical demos, execution plan analysis, and real-world examples, you'll learn when these features help, when they don't, and how to measure their impact. You'll leave with a clear understanding of how to reduce CPU pressure, improve throughput, and delay costly scale-up decisions by making better use of the optimizer capabilities already available in modern versions of SQL Server and Azure SQL.

Whether you're responsible for on-premises environments, Azure SQL databases, or hybrid deployments, this workshop provides practical techniques that you can apply immediately to improve performance and reduce operational costs.


Prerequisites: Basic knowledge of T-SQL, execution plans, and query tuning is recommended. Attendees do not need prior experience with Intelligent Query Processing features. Examples are based on SQL Server 2017 to SQL Server 2025, and Azure SQL Database. Feature availability may vary depending on edition, compatibility level, and deployment model.

Uwe Ricken

db Berater GmbH - Managing Director

Frankfurt am Main, Germany

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top