Session

Query Store: The simplest way to Troubleshooting Performance

I live and breathe in Query Store everyday as a Performance Tuning consultant. I am able to quickly find performance issues without knowing my clients code or applications to help them fix or discover on going 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, we'll cover how you can use the Query Store to answer the question “Why was my query slow?"

Monica Rathbun

Denny Cherry & Associates Consulting

Chesapeake, Virginia, United States

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top