O'Reilly logo

SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance by Grant Fritchey

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

Active Server Pages (ASP)
Adaptive query processing
interleaved execution
anti-patterns
Clustered Index Seek and Table Scan
estimated number of rows
execution plans
execution times
multistatement functions
parameter sniffing
properties
run a query
WHERE clause
mechanisms
memory grant feedback
bigTransactionHistory table
DATABASE SCOPED CONFIGURATION
DISABLE_BATCH_MODE_MEMORY_GRANT_FEEDBACK
execution plan
Extended Events
inadequate memory
memory_grant_feedback_loop_disabled
memory_grant_updated_by_feedback event
row mode execution
types
Ad hoc workloads
definition
forced parameterization
optimization
plan reusability
non reusability of existing plan
non reuse of existing plan
from procedure cache
sys.dm_exec_cached_plans output
prepared workload
simple parameterization
autoparameterized ...

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