O'Reilly logo

Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries by Grant Fritchey, Tracy Boggiano

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Tracy Boggiano and Grant Fritchey 2019
T. Boggiano, G. FritcheyQuery Store for SQL Server 2019https://doi.org/10.1007/978-1-4842-5004-4_9

9. Troubleshooting Issues with Query Store

Tracy Boggiano1  and Grant Fritchey2
(1)
Cary, NC, USA
(2)
Grafton, MA, USA
 
Like any other aspect of SQL Server, most of the time, you can simply turn Query Store on and then not worry about it. However, like any other aspect of SQL Server, things can go wrong. There are two tools that you can use to understand what is happening with Query Store on your database:
  • Query Store specific wait statistics

  • Extended Events for Query Store

This chapter will look at some common problems that can arise with Query Store and how you can use the tools provided in order to ensure that Query ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required