What is SQL Server on Azure Virtual Machines?
SQL Server on Azure Virtual Machines enables running SQL Server on Azure VMs with full control over the database engine and operating system. Unlike the PaaS offerings Azure SQL Database and Managed Instance, SQL Server on VMs gives you complete administrator access: you can choose SQL Server versions, control patches yourself, and use features like Failover Cluster Instances or Replication.
The service combines Infrastructure-as-a-Service flexibility with Azure-specific benefits like automated backups, patching automation, and integration with Azure Security Center.
Key Features
- Full SQL Server Versions: Support for SQL Server 2012 through 2022 in all editions (Standard, Enterprise, Developer)
- OS-Level Access: Full RDP/SSH access to Windows or Linux VMs
- SQL IaaS Agent Extension: Automated backups, patching, and monitoring without manual effort
- Always On Availability Groups: High availability and disaster recovery with synchronous and asynchronous replication
- Azure Hybrid Benefit: Use existing SQL Server licenses for up to 55% cost savings
Typical Use Cases
Workloads with Special SQL Features: Applications requiring Failover Cluster Instances, Transactional Replication, or other features not available in PaaS.
Version-specific Requirements: Running older SQL Server versions or applications with dependencies on specific SQL Server builds.
Lift-and-Shift with Full Control: Migrating existing SQL Server workloads to the cloud while maintaining administrative control and processes.
Benefits
- Maximum Flexibility: Full control over SQL Server configuration, versions, and patches
- License Flexibility: Pay-as-you-go or Bring Your Own License with Azure Hybrid Benefit
- Azure Integration: Automated backups to Blob Storage, integration with Azure Monitor and Defender for SQL
- High Availability: 99.99% SLA with Availability Zones and Always On Availability Groups
Frequently Asked Questions about SQL Server on Azure VMs
When should I choose SQL Server on VMs instead of Managed Instance?
Choose SQL Server on VMs when you: need specific SQL Server versions, want to use Failover Cluster Instances, require OS-level access for third-party tools, or want to maintain existing administration processes. Managed Instance is better for more modern workloads with less management overhead.
Which VM sizes are recommended?
For production, Microsoft recommends the Edsv5 or Ebsv5 series with Premium SSD or Ultra Disk storage. For OLTP workloads, at least 4 vCPUs and 16 GB RAM are recommended. Memory-intensive analytics benefit from M-Series VMs.
How does the SQL IaaS Agent Extension work?
The extension registers your SQL Server VM in the Azure Portal and enables automated backups to Azure Storage, automatic patching on schedule, performance monitoring, and integration with Azure Defender for SQL. The extension is free and requires no restart.
Can I bring my own SQL Server licenses?
Yes, with Azure Hybrid Benefit you can use existing SQL Server licenses with Software Assurance. This reduces costs by up to 55%. You can also switch between BYOL and pay-as-you-go.
How do I secure SQL Server on Azure VMs?
Use Azure Defender for SQL for vulnerability assessment and threat detection. Enable Transparent Data Encryption and Always Encrypted for data encryption. Use Network Security Groups and Private Endpoints for network isolation.
Integration with innFactory
As a Microsoft Solutions Partner, innFactory supports you with SQL Server on Azure VMs: from sizing consultation and migration to high availability setup to ongoing performance optimization and cost reduction.
