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, ...
Get SQL Server 2016 Developer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
