Empowering SQL: Mastering Intelligent Query Processing in 20 Minutes
summary
Covers concrete IQP changes across SQL Server 2017, 2019 and 2022: Query Store is now default and persists runtime metadata so memory grant feedback survives cache evictions and uses percentile-based history; interleaved execution obtains exact cardinality for multi-statement TVFs to avoid 100-row defaults; adaptive join flips nested loop to hash match on the fly when cardinality is far larger than estimated; parameter sensitive plan optimization auto-generates child plans for skewed parameter ranges; DOP is tuned dynamically based on observed latency.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 3:16Query Store evolution
- 6:09Adaptive Query Processing 2017
- 9:23Top 5 intelligent features
- 9:44Memory Grant Feedback deep dive
- 13:18Interleaved Execution for TVFs
- 16:34Adaptive Join optimization
- 17:37Parameter Sensitive Plan Optimization
- 19:47Degree of Parallelism optimization
- 21:12Q&A
related talks
22mEmpowering SQL: Mastering Intelligent Query Processing in 20 Minutes- 22mEmpowering SQL: Mastering Intelligent Query Processing in 20 Minutes
53mBanishing Slow Queries with Intelligent Query Processing
51mMaking the SQL Query Processor Work for you
50mBuilt-in Intelligence with Azure SQL and SQL Server 2022- 53mBanishing Slow Queries with Intelligent Query Processing
44mImproving Performance with Intelligent Query Processing
20mElevating SQL Server Performance with Query Store Hints