View Image

Optimize SQL Server Query Store performance: Improve SQL Server 2016 Query Store performance. See all Query Store properties in a single summary table. Execute predefined actions that modify Query Store properties and contents. Edit all modifiable Query Store properties in single overview panel. Get up and running in minutes with no agents. Optimize the Query Store of SQL Server to improve performance: Troubleshoot issues and execute tasks that follow best practices to help keep Query Store tuned to the database workload. Improve the performance of the Query Store of SQL Server by optimizing its properties and contents. This optimization affects how the Query Store captures per database a history of queries, plans, and run-time statistics. See all Query Store properties in a single summary table: Register one or more SQL Server instances. For a selected connected instance, display all database Query Store properties in a single summary table. This table provides an overview of all of the Query Store properties to compare properties across Query Stores, to identify quickly the origin of performance problems, and to select a Query Store quickly to optimize its performance. Execute predefined actions: For a selected database, provide predefined Query Store actions including clear Query Store contents, restart Query Store, recover from memory corruption, recover from disk corruption, set Query Store to default settings, keep only most relevant data in Query Store, flush Query Store in-memory cache to disk, and find and delete ad-hoc queries executed only once and older than 24 hours. Edit Query Store properties in single overview panel: For a selected database, display all of the twelve properties of its Query Store in a single summary panel, and allow editing of all eight modifiable properties. Together with the summary table, this allows for quick selection of Query Stores and optimizing their performance. In contrast, SQL Server Management Studio