Abstract
As with any SQL Server feature, maximizing its potential involves tuning that feature for your specific environment. Common advice would be to begin with the defaults, then compare these with commonly agreed best practices and adjust those to what makes sense for your use case if necessary. Often there will be a widely accepted set of best practices within the community for typical deviations from Microsoft defaults. Sometimes defaults that appear “dumb” are often set that way, not because Microsoft is ignorant of its product or user base but for backward compatibility reasons.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor 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). Configuring Query Store. In: Query Store for SQL Server 2019. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5004-4_3
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5004-4_3
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)