SQL Server on Azure VM - Configuring for price-performance
summary
Recommends running SQL Server on Ebdsv5 + Premium SSDv2 VMs, showing disk and VM limits: P30 = 5,000 IOPS, Ebdsv5 VM uncached/local temp up to 38,000 IOPS and VM-level cap ~12,800 IOPS, Premium SSDv2 configurable to 3,000–80,000 IOPS, Ultra to 160,000 and a public‑preview NVMe option to 260,000 IOPS. Demonstrates IO capping, when to enable host caching vs no host caching (reads cached, writes bypass), cites a $1.53 per 1k new orders/min price‑perf benchmark and marketplace images plus SQL IaaS Agent for backups/patching.
AI-written summary · about
chapters (13)
- 0:00Introduction to SQL on Azure VMs
- 1:04Why choose Azure VMs for SQL Server
- 3:14Memory-optimized VMs for SQL Server
- 6:06Understanding VM naming conventions
- 7:56Azure VM disk provisioning basics
- 13:14Measuring workload for VM selection
- 15:22Golden rule: Pick ebdsv5 VMs
- 18:39Choosing the right storage type
- 23:58Understanding IO capping limits
- 28:58Host caching for performance
- 33:12Best practices for SQL on Azure VMs
- 36:05Marketplace images and extensions
- 38:37Q&A session
related talks
49mSQL Server on Azure VM - Configuring for Price-Performance
59mWhat's new on Azure IaaS for SQL Server VMs
54mAzure Best Practices for Lift and Shift
50mSQL Server to Azure SQL: Performance and Availability
51mFly at Mach-speed with Azure SQL Managed Instance- 51mFly at Mach-speed with Azure SQL Managed Instance
01h 01mSQL Server in the Cloud - The available options
47mArchitecting for High Performance SQL Server on Virtual Machines