-
Book Overview & Buying
-
Table Of Contents
Introducing Microsoft SQL Server 2019
By :
The Query Store in SQL Server, first introduced in SQL Server 2016, streamlines the process of troubleshooting query execution plans. The Query Store, once enabled, automatically captures query execution plans and runtime statistics for your analysis. You can then use the sys.dm_db_tuning_recommendations view to discover where query execution plan regression has occurred and use the stored procedure, sp_query_store_force_plan, to force a specific plan that performs better.
In SQL Server 2019, we now have made some additional enhancements to the default Query Store features. In this section, we will discuss the following topics:
QUERY_CAPTURE_MODE customYou can configure Query Store with SQL Server Management Studio (SSMS) or with T-SQL statements. SSMS configuration includes turning it on and off by setting the operation mode (off, read...