SQL Server 2022 hidden gems
summary
Live demos show new diagnostic and ops features: query_abort XEvent captures the aborted query text plus T‑SQL call stacks (using Arvin’s call‑stack tool) so timeouts, cancels and kills are distinguishable; query anti‑pattern XEvents flag conversions that prevent index seeks. TempDB gets metadata optimization removing latch hotspots (demo: one-file hammer drops latch waits to zero), autogrow zeroing drops from ~17s to ~7s and VLFs drop from 51 to 26, and T‑SQL snapshot backups to Azure storage and parquet archiving via external tables are proven and scripted on GitHub.
AI-written summary · about
chapters (10)
- 0:00Introduction to hidden gems
- 2:53Query anti-patterns
- 7:10Query abort diagnostics
- 16:06Schema modification locks
- 18:11TempDB optimization
- 26:43Q&A session
- 28:08Snapshot backups
- 34:00Log file improvements
- 40:47Q&A session two
- 43:05Data archiving and wrap-up
related talks
49mHidden Gems in SQL Server 2022 Database Engine- 49mHidden Gems in SQL Server 2022 Database Engine
49mPerformance Features in SQL Server and Azure SQL
50mSQL Server 2022 Performance Enhancements
52mWriting T-SQL code for the engine, not for you "more demos" by popular demand- 50mSQL Server 2022 Performance Enhancements
50mAchieve peak performance and availability for your SQL Server and Azure SQL workloads with core engi
49mPerformance Improvements in SQL Server 2019