Achieve peak performance and availability for your SQL Server and Azure SQL workloads with core engi
summary
Shows concrete engine features: metadata versioning (allows DDL and snapshot reads to run concurrently, currently in Azure preview for ALTER TABLE), optimized locking (transaction‑ID locks plus lock‑after‑qualification reduces locks from millions to <10 and lock memory from ~900MB to <10MB in demos), and accelerated database recovery (per‑database persisted version store + special log stream gives near‑instant undo and redo—5M‑row crash demo finishes recovery in ~3s). Also covers columnstore sort support and contained availability groups that replicate master/msdb to replicas.
AI-written summary · about
chapters (7)
- 0:00SQL Server performance features
- 1:13Metadata versioning scalability
- 16:30Optimized locking in SQL Server
- 25:51Instant recovery with ADR
- 39:39Column store index enhancements
- 42:33High availability and disaster recovery improvements
- 48:25Contained availability groups
related talks
50mAchieve peak performance and availability for your SQL Server and Azure SQL workloads with core engi
50mSQL Server to Azure SQL: Performance and Availability
51mThe 10 things every developer must absolutely know about Azure SQL
49mPerformance Features in SQL Server and Azure SQL
49mAnalytics in SQL Server and Azure SQL Database
01h 15mChoose Azure SQL Database and Learn What Every Developer Should Know
53mOptimizing your Azure SQL Database workloads
43mLearn Azure SQL Database through Demos