O'Reilly logo

Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries by Grant Fritchey, Tracy Boggiano

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Index

A

ad-hoc queries
AdventureWorks database
Automatic plan correction
automatic tuning
SeeAutomatic tuning
behavior
capabilities
concepts
regression
SeeRegression
Automatic plan regression correction (APRC)
disable T-SQL
enable T-SQL
Automatic tuning
Azure portal
CurrentState value
performance
regression
T-SQL command

B

Baseline
catalog views
compare workload back
create
definition
establish
overall resource consumption
performance

C

Catalog view, Query store
Compiled stored procedures
Configuration options
cache per query
capture queries
changing, GUI
CUSTOM mode
database renaming
data clean up
data flush interval
drop /create
interval data
maximum storage size
operational mode
parameterization
STALE_QUERY_THRESHOLD_DAYS
trace flag
wait statistics
Copy-DbaQueryStoreConfig
database
CPU, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required