© 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 ...

Get Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.