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, ...
Get Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
