Summary
Query Store is a great troubleshooting tool which captures all execution relevant parameters for database queries: query details, execution plans, and runtime statistics and stores them in the same database so that they can survive after server failures. All that is done out-of-the-box, with minimal impact on the database workload.
By using Query Store, you can not only quickly identify performance regressions, but also mitigate them by forcing a well-known and previously used execution plan. Query Store will save you time and money. It also helps you to learn how your database workload changes over time and to identify queries that did not execute successfully.
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.
