Saturday, May 30, 2015

What is the SQL Server 2016 Query Data Store?

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:
  1. Stores the history of query plans
  2. Captures performance data for each query plan
  3. Identifies the most expensive queries and earmarks those queries that have degraded or gotten slower over time
  4. Gives you the ability to force old plans, should a new plan cause performance issues (almost like a system restore for Windows computers)
  5. Easily fixes plan regressions
  6. Analyzes workload patterns
  7. De-risks SQL Server upgrades with restart and failover

Read more

No comments:

Post a Comment