Automatic Query Tuning in Microsoft SQL Server - Plan Correction

Abstract

Microsoft has introduced Automatic Query Tuning as part of the Query Store in SQL Server 2017. In this session (level 300 - 400), we will use some practical examples to understand how automatic plan correction works to counteract plan regression and plan instability and learn the limitations of this feature.

About the speaker

Torsten Strauß (MCT, MCSE Data Platform, MCSE Data Management and Analytics) has been working with Microsoft SQL Server since the turn of the millennium.
He currently works as Database Engineer and Microsoft SQL Server Evangelist for BP Europe SE and as CEO of inside-sqlserver.
Torsten has delivered more than 100 presentations about Microsoft SQL Server at national and international conferences and user groups and has been recognized as a Microsoft Data Platform MVP since July 2018.