Performance that Just Works: SQL Server 2025 Engine Enhancements
Proposed session for SQLBits 2026TL; DR
Discover how SQL Server 2025 boosts performance with smarter query processing and improved concurrency. Learn how these upgrades make workloads faster, more predictable, and easier to tune.
Session Details
SQL Server 2025 arrives with a fresh batch of performance upgrades that make the engine faster, more predictable, and much less dramatic under pressure. This session breaks down the improvements that matter most, from smarter query processing to new concurrency features that help reduce blocking and boost throughput.
We’ll explore enhancements like Transaction-ID (TID) locking, lock-after-qualification, and the latest Intelligent Query Processing advances that help SQL Server quietly fix your query problems without asking you to rewrite half your codebase.
If you've ever wished SQL Server would stop acting like a bottleneck and start acting more like a partner, this session will show you the new capabilities that make that wish a little closer to reality.
We’ll explore enhancements like Transaction-ID (TID) locking, lock-after-qualification, and the latest Intelligent Query Processing advances that help SQL Server quietly fix your query problems without asking you to rewrite half your codebase.
If you've ever wished SQL Server would stop acting like a bottleneck and start acting more like a partner, this session will show you the new capabilities that make that wish a little closer to reality.
3 things you'll get out of this session
Learn the key performance and concurrency enhancements in SQL Server 2025 and how they improve workload throughput.
Understand the latest Intelligent Query Processing improvements and how they boost performance with minimal code changes.
Discover practical ways to apply these features to reduce blocking and improve overall query stability.