Introduction to SQL Server Query Store

Query store – what is it and why should you care? It’s an option in SQL Server that records query plans and wait states. And the cool thing is? It gives you a deeper understanding of historical performance data. With query store, you get an answer to the question, "Is this worse now than then?" Query store also provides an easy, effective way to force a plan to be used.

In this on-demand webcast, you’ll learn about:

• Performance impact and disk usage
• The simple per database configuration
• What query store can capture and the tables used
• Forcing and unforcing a plan
• Plan regression and how you find it using the built-in reporting

Speakers

• Andy Warren - SQL Server consultant