Query processing in SQL Server 2022 – Intelligent++ ?

This page contains the description for my conference session “Query processing in SQL Server 2022 – Intelligent++ ?”.

Description

Target audience Experienced database developers and DBAs.
Short description An overview of the “NextGen Intelligent Query Processing” features, announced for SQL Server 2022. What they do, how they work, and benefits and limitations.
Duration The ideal length for this session is 60 minutes.
Full abstract Microsoft has done a lot of work since SQL Server 2016 to make performance tuning easier. Query Store, Adaptive Query Processing, Intelligent Query Processing, and Automatic Tuning have been released in the past years. And now “NextGen Intelligent Query Processing” has been announced for SQL Server 2022. But what does this mean? What can you expect? And most important question: Will ALL queries now always finish fast, or are your tuning skills still relevant?

Resources

The slide deck and demo code for this session are currently not yet available. They will be uploaded here by the time this session is presented for the first time.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close