Empowering SQL: Mastering Intelligent Query Processing in 20 Minutes
summary
Intelligent Query Processing is traced from 2017 to 2022: it learns from runtime plans and actually changes execution on the fly. Key concrete features are memory grant feedback (now persisted to Query Store so grants survive cache evictions), adaptive join and interleaved execution (switches nested-loop to hash match midrun to avoid spills), plus 2019/2022 additions like table-variable deferred compilation, batch-mode scalar UDFs, parameter sensitive plan optimization, cardinality-estimate feedback, DOP tuning and read-replica support — all applied automatically to reduce spills, fix bad plans and lower 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- 53mBanishing Slow Queries with Intelligent Query Processing
44mImproving Performance with Intelligent Query Processing
50mBuilt-in Intelligence with Azure SQL and SQL Server 2022
51mMaking the SQL Query Processor Work for you
49mPerformance Features in SQL Server and Azure SQL