mssqltips logo

Introduction to SQL Server Query Store

(this is an on-demand video)

Sponsored by - Quest

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.




More SQL Server Solutions












download





get free sql tips

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.



Learn more about SQL Server tools