Ensuring Plan Stability with Query Store

Erin Stellato
60 minutes
Enterprise Database Administration & Deployment
SQL Server 2016 introduced Query Store, a new feature which tracks query metrics and can be used for troubleshooting, testing, and proactively monitoring a workload. Query Store also provides the ability to force a plan for particular query, which means you may no longer need to use those tricky plan guides. In this session, we'll start with a quick review of how Query Store works. Then we'll examine plan forcing in depth, including why a forced plan will fail and how plan forcing compares to using plan guides. Expect a lot of demos as we investigate how Query Store can help you do more than just troubleshoot issues, but also manage query performance.

Accompanying Material

No material found.

Back to Top cage-aids