~/talk

Fly at Mach-speed with Azure SQL Managed Instance

Talkat SQLBits 2022 · 2022-03-08..03-12· [cloud-infrastructure, databases]
links:none on file
links:none on file
links:none on file
slides:none on file

Azure SQL Managed Instance upgrades its storage from premium page blobs to premium managed disks, cuts average latency to about 3–4 ms, and exposes an IOPS slider with a cap computed as vCores × 1.6k (bounded at 880,000). Compute now scales to 128 vCores and storage to 32 TB with up to 500 databases per instance; demos show TPC-H runs roughly 3× faster and spikes to ~250k TPS versus ~6k on legacy GP. Upgrade is online; extra IOPS are billable.

AI-written summary · about

  1. 0:00Azure SQL Managed Instance intro
  2. 1:10Faster DB performance matters
  3. 2:36Current tiers and limits
  4. 5:06Demand for flexibility
  5. 8:22Next-gen general purpose tier
  6. 10:31Storage upgrade to managed disks
  7. 13:47Performance and scalability gains
  8. 15:12Live demo: old vs new tiers
  9. 19:34Storage scalability and limits
  10. 23:12Compute layer enhancements
  11. 26:46IOPS flexibility with slider
  12. 29:58High availability in next-gen GP
  13. 32:46Pricing details
  14. 36:00Free SQL MI and savings
  15. 37:04Q&A
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.