-
Book Overview & Buying
-
Table Of Contents
Introducing Microsoft SQL Server 2019
By :
Automatic tuning identifies potential query performance problems, recommends solutions, and automatically fixes problems identified.
By default, automatic tuning is disabled and must be enabled. There are two automatic tuning features available:
To take advantage of automatic plan correction, the Query Store must be enabled on your database. Automatic plan correction is made possible by constantly monitoring data that is stored by the Query Store.
Automatic plan correction is the process of identifying regression in your query execution plans. Plan regression occurs when the SQL Server Query Optimizer uses a new execution plan that performs worse than the previous plan. To identify plan regression, the Query Store captures compile time and runtime statistics of statements being executed.
The database engine uses the data captured by the Query Store to identify...