Query Data Store in SQL Server 2016 is intended as a service that monitors and optimizes query plans with full history of query execution. Query Data Store can help diagnose performance problems that are related to plan changes.
What it does:
- Stores the history of query plans
- Captures performance data for each query plan
- Identifies the most expensive queries and earmarks those queries that have degraded or gotten slower over time
- Gives you the ability to force old plans, should a new plan cause performance issues (almost like a system restore for Windows computers)
- Easily fixes plan regressions
- Analyzes workload patterns
- De-risks SQL Server upgrades with restart and failover
Read more http://windowsitpro.com/sql-server-2016/what-sql-server-2016-query-data-store
No comments:
Post a Comment