SQLBits 2023

Built-in Intelligence with Azure SQL and SQL Server 2022

"Learn about the Intelligent query processing feature family such as improvements to memory grant feedback, degree of parallelism (DOP) feedback, parameter sensitive plan optimization, and more - that help business-critical workloads run at scale, without changing your application code. We will cover the intelligent database feature family, the database compatibility levels, and troubleshooting with query store hints."
Intelligent query processing is a key component to help business-critical workloads improve when running at scale, while remaining adaptive to the constantly changing world of data.

In this session we will cover how the latest SQL Server versions improve performance with features and enhancements under the intelligent database feature family. These features include query store and intelligent query processing that helps improves performance and scalability with minimal changes to your application or database design.

We will cover the scenarios where intelligent query processing can have the most benefit for your application workloads and how Query Store can help make it easier to identify poorly performing statements and respond to regression scenarios. We will cover Query Store use cases such as Query Store internals, performance regressions, and improvements in the latest versions of SQL Server including the new Query Store Hints improvement.