Details

Query Store

Speaker: Sam Mesel

Duration: 60 minutes

Track: 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
cage-aids
cage-aids
cage-aids