Abstract
The information captured and stored within Query Store begins to open up new functionality for Microsoft and you. First, for Microsoft, having the ability to identify a query that has suffered from a regression (as we describe in Chapter 7) means that they can monitor the system and, using the information in the Query Store, automate forcing a plan to fix the regression. This is the Auto Plan Correction at work. Second, for us, the addition of wait statistics within the Query Store information opens up additional troubleshooting possibilities.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Tracy Boggiano and Grant Fritchey
About this chapter
Cite this chapter
Boggiano, T., Fritchey, G. (2019). Auto Plan Correction and Wait Statistics. In: Query Store for SQL Server 2019. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5004-4_8
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5004-4_8
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5003-7
Online ISBN: 978-1-4842-5004-4
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)