Webinar:

Introduction to Query Store

Overview:

Date: Wednesday, February 10
Time: 11am ET
Length: 1 hour, 20 min

Summary:

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.

Register Now

Kevin Kline

Kevin Kline

Head Geek, SolarWinds

Kline is a noted database expert and software industry veteran. At previous companies, his product designs won multiple "Best of" and "Readers' Choice" awards.

Kline was a founding board member and former president of the Professional Association for SQL Server (PASS), is an avid blogger and database columnist, author of the best-selling book, SQL in a Nutshell, and co-author of SQL Server 2012 Management and Administration, Professional SQL Server 2008 Database Design and Optimization, and Database Benchmarking: Practical Methods for Oracle & SQL Server. He is a frequent webinar host and speaker at various industry conferences and user groups and has traveled the world as part of his multi-continent roadshows.

A Microsoft SQL Server MVP since 2003, Kline is passionate about improving the quality of life for Microsoft database professionals and their customers. As a SolarWinds Head Geek, he focuses on helping customers with troubleshooting and adopting best practices for optimal database performance monitoring, on-premises and in the cloud.

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