This wiki has been retired. For the latest information on running SQL Server on Azure Virtual machine, see this link:
We'll use this wiki to communicate best practices you should consider when provisioning and deploying SQL Server in a Azure Virtual Machine.
Azure Virtual Machine was designed to support a broad range of SQL Server workloads. As with any preview, you should start testing small workloads first and measure throughput and performance. Move on to test more demanding workloads as you gain confidence
in the performance, reliability and availability of the service. Consider these guidelines when evaluating which workloads to test. Run some performance tests (seePredeployment
I/O Best Practices) to help you compare baseline performance of virtual machines running in Windows Azure Virtual Machine to other platforms.
Big thanks to
Sandino Di Mattia for writing these up!
A SQL Server VM in Windows Azure can be added as a replica to an on-premise
AlwaysOn Availability Group. This enables a disaster recovery solution for an on-premise SQL Server. If the on-premise SQL Server fails, you can failover the Availability Group to the SQL Server VM replica. In addition, you can configure the
SQL Server VM as readable, to offload read workloads and backups.
The steps involved are:
Please note the following caveats with regards to application connectivity:
SQL Server in Windows Azure Virtual Machine Early Adoption Cook Book (en-US)