Query Store

Sam Mesel
60 minutes
Database Administration
Analyzing query performance can be tricky. It involves knowing several dynamic management views (DMVs) and accessing query plans that are still in the query cache. If you need to get performance metrics for a query which is no longer in the cache, or if your server is restarted it will be an impossible task. Query Data Store is a new feature that comes to help DBAs. By persisting query execution data over time, it allows reviewing of statements / plans / properties / statistics. This session will show you how to enable and use Query Store features, like: obtaining queries with plan changes over time; analyze queries by CPU / Memory / other counters; forcing a plan; and other gems.

Back to Top cage-aids