What is Query Store?

Query Store is the answer to the challenges described above. It collects the most relevant information about the executed queries: query text, parameters, query optimization and compilation details, execution plans, and execution statistics (execution time, CPU and memory usage, I/O execution details) and stores them in a database so that they are available after server restarts, failovers, or crashes.

You can use Query Store not only to identify performance issues, but also to fix some of them. Query Store offers a solution for issues caused by changed execution plans. By using Query Store, you can easily enforce the old plan; it is not required to rewrite the query or to write any code. You don't affect the business logic, therefore there is no need for testing, there is neither code deployment nor application restart. By taking this approach you can quickly implement a solution or at least a workaround, and save time and money.

Note

In addition to this, stored information...