Banishing Slow Queries with Intelligent Query Processing
summary
Overview of SQL Server Intelligent Query Processing features and live demos showing concrete effects and requirements. Demonstrations use WideWorldImporters with 20M rows, showing table variable deferred compilation changing an estimated row count from 1 to 228,000 when compatibility level is raised, memory grant feedback clearing excessive grant warnings after a re-run, and degree of parallelism feedback stepping a query from MAXDOP 16 down toward 2 then stabilizing at 4. Query Store and appropriate compatibility levels are required for several features.
AI-written summary · about
chapters (9)
- 0:00Start
- 1:34Denny Cherry & Associates
- 4:01CHALLENGE ACCEPTED
- 6:10SQL Server 2022 IQP
- 11:29Table Variables Issues
- 12:09Table Variable Deferred Compilation
- 15:07Memory Grant Feedback
- 19:34Parameter Sensitive Plan
- 28:45DOP Feedback Architecture
related talks
53mBanishing Slow Queries with Intelligent Query Processing- 53mBanishing Slow Queries with Intelligent Query Processing
44mImproving Performance with Intelligent Query Processing
22mEmpowering SQL: Mastering Intelligent Query Processing in 20 Minutes- 22mEmpowering SQL: Mastering Intelligent Query Processing in 20 Minutes
19mStabilizing Performance with Query Store- 19mStabilizing Performance with Query Store
51mMaking the SQL Query Processor Work for you