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, queries
D
Database Platform as a Service (PaaS)
Database properties
Data Definition Language (DDL)
Data flush interval
Data Manipulation Language (DML)
dbatools
Copy-DbaQueryStoreConfig
Get-DbaDbQueryStoreOption
Set-DbaDbQueryStoreOptions
Desired state
vs.
actual state
Drop/create
vs.
alter
Dynamic Management Function (DMF)
Dynamic Management Views (DMVs)
disadvantages
query_plan_hash field
sp_whoisactive
sql_handle field
E
ERROR state
Estimated plan
vs.
actual plan
Event tracing for windows (ETW)
Execution plans/query plans
compare
forcing/unforcing
check mark
forced programmatically
reports
T-SQL
regressed queries identification
query store data
report
warning signs
errors
estimated
vs.
actual plan
fat pipes
first operator
most costly operator
scans
sort operator
Extended events
database
evaluate and capture
information capture
selecting events
tracking behaviors
troubleshooting
concepts
disadvantages
template directory
XEvent profiler, SSMS
F
First-in-first-out (FIFO) method
FREEPROCCACHE procedure
G, H
The Game Changer, Query store
automatic plan correction
runtime statistics
use cases
wait statistics
Get-DbaDbQueryStoreOption
AdventureWorks
database
output
ReadWrite
table format
I, J, K, L
Infrastructure as a Service (IaaS)
M
master system database
Memory-optimized tables
@module_or_batch
N
Naming convention
O
OBJECT plan guides
OPTION clause
Overall Resource Consumption report
buttons
configure button options
configure time interval drop-down
hover statistics
standard grid view
P
Performance
plan cache, removing
plan guides/USE PLAN hint
stored procedure
UPDATE STATISTICS
Plan forcing
Plan handle
query to retrieve
set options retrieve
Q
Queries with Forced Plan report
right/left-hand pane
Queries with High Variation report
high variation report
parameterization
summary information
Query optimizer
Query Store
actual state
asynchronous process
clear the data
configuration
SeeConfiguration options
data collection
data sets
DDL
default options
desired state
DML
execution plan
execution_type
object explorer reports
plan removed
properties window
remove a plan
runtime interval
runtime statistics
settings and diagnostics
space usage
sys.database_query_store options
sys.query_context_settings
sys.query_store_plan
sys.query_store_query
sys.query_store_query_text
sys.query_store_runtime_stats
sys.query_store_runtime_stats_interval
sys.query_store_wait_stats
T-SQL
wait_category
wait statistics
Query Wait Statistics report
categories
grid view
top five
R
Read-only state
Regressed Queries report
force/unforce plan buttons
plan options
types
Regressed query
compare plan
compare report
definition
plan
Regression
automatic tuning
dbo.ProductByCost stored procedure
dynamic management view
execution plan
FREEPROCCACHE
JSON data
query performance
stored procedure
sys.dm_db_tuning_recommendations
tuning recommendations DMV
Runtime information
S
Set-DbaDbQueryStoreOptions
AdventureWorks
database
output
size and collection interval
SET options
function to retrieve
query to return
sp_BlitzQueryStore
date range
parameters
result set
time period analysis
SQL plan guides
SQL Server Management Studio (SSMS)
SQL Server upgrade
CE
compatibility modes
testing process
Standard Grid view
sys.database_query_store options catalog view
SQL Server
sys.query_context_settings catalog view
sys.query_store_plan catalog view
sys.query_store_query catalog view
sys.query_store_query_text catalog view
sys.query_store_runtime_stats catalog view
sys.query_store_runtime_stats_interval catalog view
sys.query_store_wait_stats catalog view
sys.sp_force_plan
T
tempdb system database
TEMPLATE plan guides
Top Resource Consuming Queries Report
buttons
columns
configuration screen
grid view
hover over query plan
ID data
left-hand pane
metric
option bar
plan grid view
plan operator comparison
report details comparison
right-hand pane
SQL Server
statistics
Tracked Queries Report
magnifying glass view
statistics details
Troubleshooting
DMF
DMVs
disadvantages
sp_whoisactive
Extended Events
SeeExtended events, troubleshooting
lightweight show plan trace flag
server-side traces
SQL server profiler
concepts
event classes
filter screen
use cases
wait statistics
U, V
USE PLAN parameter
W, X, Y, Z
Wait statistics
categories
mapping table
querying
dbo.ProductbyCost
report
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.