Banishing Slow Queries with Intelligent Query Processing
summary
Overview of SQL Server features that fix slow queries by changing nothing in app code: engine-side table variable deferred compilation shifts estimate from one row to 228,000 in the demo, producing much better plans; memory grant feedback reduces spills by adjusting grants after a run; parameter sensitive plan (2022) creates dispatcher + variants for different cardinalities; DOP feedback automatically lowers degree from 16 toward 4 over repeated runs. Demos use Wide World Importers, Query Store is required for several features, some features need Enterprise.
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
22mEmpowering SQL: Mastering Intelligent Query Processing in 20 Minutes
44mImproving Performance with Intelligent Query Processing
50mBuilt-in Intelligence with Azure SQL and SQL Server 2022
51mMaking the SQL Query Processor Work for you- 22mEmpowering SQL: Mastering Intelligent Query Processing in 20 Minutes
19mStabilizing Performance with Query Store