Abstract
Have you ever had a performance problem due to the fact that a query unexpectedly got a different execution plan? Have you ever found a plan regression after a SQL Server upgrade and wanted to know what the previous execution plan for a query was? The Query Store, a new feature in SQL Server 2016, can help you to troubleshoot and solve these and other performance problems related to changes in execution plans.
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
© 2016 Benjamin Nevarez
About this chapter
Cite this chapter
Nevarez, B. (2016). The Query Store. In: High Performance SQL Server. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-2271-3_3
Download citation
DOI: https://doi.org/10.1007/978-1-4842-2271-3_3
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-2270-6
Online ISBN: 978-1-4842-2271-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books