Query Store: The Simplest Way to Troubleshooting Performance

Monica Rathbun

I live and breathe in Query Store every day as a Performance Tuning consultant. I am able to quickly find performance issues without knowing my client’s code or applications, to help them fix or discover ongoing performance issues.

The Query Store feature provides you with insight on query plan choice and performance. It gives you more control over which execution plans the optimizer will utilize and insights into plan regressions.

In this session, we’ll discuss what the Query Store is, how it works, how you should configure it for your environment, and how to get even more information by using the underlying DMVs that support it. We’ll learn how to quickly find performance differences caused by query plan changes, identify quick performance anomalies, and solve performance issues in minutes using a combination of discussion and demos. Overall, we’ll cover how you can use the Query Store to answer the question: “Why was my query slow?”