Introduction to SQL Server Query Store


Quest sponsored on-demand webinar

Webcast Abstract

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!

Speaker - Andy Warren

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.





download





get free sql tips
agree to terms


Learn more about SQL Server tools