What's new on Azure IaaS for SQL Server VMs
summary
Covers concrete sizing and deployment choices: recommends Dsv2/Mv2 families for best vCPU/IOPS ratios, enforces minimum four cores for SQL licensing, shows ARM templates and a demo repo (GitHub: OmegaMadLab/SqlIaasVmPlayground) and an optimized ARM template, and explains using the SQL IaaS extension and the licensing slider so passive DR nodes under Software Assurance are free for 2019 licenses. Details use of temporary disk for tempdb, proximity placement groups to cut latency, and Azure Files-based failover clusters.
AI-written summary · about
chapters (12)
- 0:00Introduction to session
- 1:53When to use SQL Server VMs
- 8:34Performance guidelines for VMs
- 13:23Storage configuration essentials
- 20:39Disk sizing and management
- 26:25OS and SQL Server tuning
- 30:18Automation with setup provider
- 33:37Licensing and billing models
- 37:01High availability strategies
- 45:06Cluster instance with file shares
- 51:24Demo and resources
- 53:19Q&A session
related talks
49mSQL Server on Azure VM - Configuring for Price-Performance
42mSQL Server on Azure VM - Configuring for price-performance
01h 01mSQL Server in the Cloud - The available options
54mAzure Best Practices for Lift and Shift
18mHow to reduce your SQL Database costs on Azure
01h 05mHow to Get the Best Out of Your SQL Server on Azure
49mEverything you always wanted to know about HA/DR for SQL Server on Azure VMs but were afraid to ask
52mHADR on SQL Server on Azure VMs: Everything you Need to Know