Abstract
Query Store is a new SQL Server 2016 component that collects execution plans and runtime statistics for the queries in the system. It helps you to detect suboptimal queries, shows how execution plans evolve over time, and allows you to force specific plans in order to address parameter sniffing–related issues.
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 Dmitri Korotkevitch
About this chapter
Cite this chapter
Korotkevitch, D. (2016). Query Store. In: Pro SQL Server Internals. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1964-5_29
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1964-5_29
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1963-8
Online ISBN: 978-1-4842-1964-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books