Making the SQL Query Processor Work for you

on YouTube ↗51m

" summary

Upgrading a database’s compatibility level 160 (SQL 2022) often reduces CPU and duration versus 130 without code changes, because the engine applies persisted feedback from query store hints and memory‑grant feedback; feedback survives restarts and query store is on by default for new DBs. Degree‑of‑parallelism feedback steps down by two until stable (min 2). For high compile queries optimized plan forcing cuts compile time from ~1.2s to ~13ms by forcing a stored plan.

AI-written summary · about

" chapters (7)

1. 0:00SQL Query Processor intro
2. 15:29Compatibility level deep dive
3. 23:33Query Store fundamentals
4. 33:04Query Store hints & read-only secondaries
5. 33:47Intelligent query processing feedback
6. 45:04Non-feedback intelligent query features
7. 48:38Summary & Q&A

" related talks

• 51mMaking the SQL Query Processor Work for youJoe Sack, Ajay Jagannathan, Derek Wilson · SQLBits 2022
• 53mBanishing Slow Queries with Intelligent Query ProcessingJohn Morehouse · SQLBits 2023
• 53mBanishing Slow Queries with Intelligent Query ProcessingJohn Morehouse · SQLBits 2019
• 50mBuilt-in Intelligence with Azure SQL and SQL Server 2022David Pless · SQLBits 2023
• 53mBanishing Slow Queries with Intelligent Query ProcessingJohn Morehouse · SQLBits 2022
• 44mImproving Performance with Intelligent Query ProcessingJohn Morehouse · SQL Server Virtual Conference 2021
• 22mEmpowering SQL: Mastering Intelligent Query Processing in 20 MinutesHaider Raza, Manish Kumar · SQLBits 2022
• 51mNext Level Scalability on SQL Server 2022Ajay Jagannathan, David Pless · SQLBits 2023