There’s an excellent article from Microsoft that gives some great advice on saving money when running SQL Server VMs in Azure. Tips include:
- using a free edition of SQL Server (Developer or Express) where possible
- choosing the SQL meter for temporary or periodic workloads, and bringing your own licence via the Azure Hybrid Benefit for workloads with a known lifetime and scale
- correctly sizing the VM – perhaps choosing one of the special VMs that are optimised for certain types of SQL Server workloads which have a high level of resources but a lower virtualised core count
- shutting down VMs where possible, perhaps using an automatic shutdown facility
Find the article here: http://bit.ly/2Ndp7jd.