Introduction to Query Store


Query Store is a great troubleshooting tool. However, four years after its introduction with SQL Server 2016, it is still underused and it has not been embraced by customers as it deserves. In this session, you will learn about Query Store purpose, its architecture, and its internals. You’ll see what can be achieved with Query Store and how it can help you not only to identify performance issues more efficiently but also to fix some of them.

Many people have concerns about the impact Query Store can have on the production workload; this is one of the reasons why they do not use it. In this session, you will see how to configure Query Store properly so that this tool does not significantly impact your workload. After that, you'll see Query Store in action in four real-life examples. You will see what does the plan forcing mean, when it is a good idea and when not. You’ll also see how capturing waits can help you to find out, for instance whey a query was slow yesterday night.

Finally, you will learn about common issues with Query Store and how to mitigate them.


Interested in additional SentryOne webinars?  Check our webinar library.

Watch Now

Kevin Kline

Kevin Kline

Principal Program Manager, SentryOne

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at blogs.sentryone.com/author/kevinkline. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.

Miloš Radivojević

Miloš Radivojević

Principal Database Consultant

Miloš Radivojević is principal database consultant at bwin GVC, located in Vienna, Austria. He is a Data Platform MVP and specializes in performance and query tuning. He is co-founder of the SQL Pass Austria and speaks regularly at international database conferences. He is also co-author of the books SQL Server 2016 Developer's Guide, SQL Server 2017 Developer's Guide and Mastering SQL Server 2017.

Companies with the highest demands for database performance choose SentryOne