Have you ever had a performance problem due to the fact that a query unexpectedly got a different execution plan? Have you ever found a plan regression after a SQL Server upgrade and wanted to know what the previous execution plan for a query was? The Query Store, a new feature in SQL Server 2016, can help you to troubleshoot and solve these and other performance problems related to changes in execution plans.
The Query Store automatically captures the history of queries, execution plans, and runtime statistics, and it allows you to find regressions in query plans, identify expensive ...
