(this is an on-demand video)
Sponsored by - Quest
Query Store is an option in SQL Server that records query plans and wait states, giving you the ability to look at historical performance data in a "is this worse now than then" way as well a simple and effective way to force a plan to be used. We'll talk about the performance impact and disk usage, walk through the simple per database configuration, look at an example of what it can capture and the tables used, then force and unforce a plan. We'll finish up by looking at an example of a plan regression and how you find it using the built in reporting. By the end of the session you will see that giving it a try is low risk and has some real benefits, giving you something to work on after the presentation!
To access materials please fill out the form below.