Achieve peak performance and availability for your SQL Server and Azure SQL workloads with core engi
summary
Covers concrete engine features and demos: metadata versioning (Azure private preview) lets snapshot reads continue while ALTER TABLE runs by using schema-creation/schema-access locks; optimized locking introduces transaction‑ID (T) locks and lock‑after‑qualification, cutting lock acquisitions from millions to under 10 and lock memory from ~900 MB to <10 MB in a 5M‑row bulk test; accelerated database recovery uses a per‑database persisted version store and a special log stream to make recovery essentially instantaneous (demo shows one DB recovered in ~3 seconds).
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
49mPerformance Features in SQL Server and Azure SQL
51mThe 10 things every developer must absolutely know about Azure SQL
50mSQL Server to Azure SQL: Performance and Availability
53mOptimizing your Azure SQL Database workloads
51mPerformance Tuning Azure SQL Database
43mLearn Azure SQL Database through Demos
01h 15mChoose Azure SQL Database and Learn What Every Developer Should Know