Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries

© Tracy Boggiano and Grant Fritchey 2019

T. Boggiano, G. FritcheyQuery Store for SQL Server 2019https://doi.org/10.1007/978-1-4842-5004-4_3

3. Configuring Query Store

Tracy Boggiano¹  and Grant Fritchey²

(1)

Cary, NC, USA

(2)

Grafton, MA, USA

 

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 ...