Fly at Mach-speed with Azure SQL Managed Instance
summary
General purpose Managed Instance moves from premium page blobs to managed discs, cutting average latency to ~3–4 ms and raising max data IOPS to ~80k and max log throughput by ~60% to ~192 MB/s. Compute options expand to 128 vcores with finer scale steps, storage doubles to 32 TB and database limit rises to 500 databases with >4k files per DB. An IOPS slider lets instances pick included baseline IOPS (storage size ×3) and add paid IOPS up to the 880k cap; online upgrade works and demos show 3–5× speedups.
AI-written summary · about
chapters (15)
- 0:00Azure SQL Managed Instance intro
- 1:10Faster DB performance matters
- 2:36Current tiers and limits
- 5:06Demand for flexibility
- 8:22Next-gen general purpose tier
- 10:31Storage upgrade to managed disks
- 13:47Performance and scalability gains
- 15:12Live demo: old vs new tiers
- 19:34Storage scalability and limits
- 23:12Compute layer enhancements
- 26:46IOPS flexibility with slider
- 29:58High availability in next-gen GP
- 32:46Pricing details
- 36:00Free SQL MI and savings
- 37:04Q&A
related talks
51mFly at Mach-speed with Azure SQL Managed Instance
44mSQL Managed Instance: Fully managed SQL Server in Azure
52mAzure Sql DB Managed instance, a different sql server?
42mSQL Server on Azure VM - Configuring for price-performance
54mAzure Best Practices for Lift and Shift
50mAzure SQL Managed Instance Roadmap
39mModernize your applications on Azure SQL Managed Instance Q&A
50mNo no storage limits, just reach for the sky, with data virtualization in SQL MI