Abstract
Query Store keeps aggregated data of the queries and statistics for workloads that are run against your SQL Server database when it is enabled. This data can be used to help you establish a baseline for performance, troubleshoot performance issues, and stabilize performance on your database. In this chapter, we go over techniques that were used before Query Store was released, including Profiler/server-side traces, Extended Events, DMVs (Dynamic Management Views), plan guides, and sp_whoisactive. Then, we will look at how and why Query Store is a game changer for doing these activities.
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). What Is Query Store?. In: Query Store for SQL Server 2019. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5004-4_1
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5004-4_1
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)