SQL Server VM with performance optimized storage settings

Azure Public Test Date Azure Public Test Result

Azure US Gov Last Test Date Azure US Gov Last Test Result

Best Practice Check Cred Scan Check

Bicep Version

Deploy To Azure Deploy To Azure US Gov Visualize

Solution overview and deployed resources

Before deploying the template you must have the Virtual Network and Subnet in the same location. To learn more about how to deploy the template, see the quickstart article.

This deployment will create a VM running SQL Server with SQL Data, Log, and Temp DB file on different drives. The user specifies the number of managed disks used for SQL Data and Log files. Temp DB would use local SSD (D:) and a scheduled task would be created to create Temp DB folder structure and start default SQL Instance if local SSD is reset during VM restart. SQL Server will use Windows Authentication.

The following resources are created:

  • A Network security group allowing RDP into VM.
  • A Public IP address.
  • A Virtual Machine joined the existing vNet.
  • Managed Disks for SQL Data and Log.
  • A SQL Virtual Machine resource attached to the VM.

Tags: Azure, SQL, VirtualMachine, Performance, StorageConfiguration, Microsoft.Network/publicIPAddresses, Microsoft.Network/networkSecurityGroups, Microsoft.Network/networkInterfaces, Microsoft.Compute/virtualMachines, Microsoft.SqlVirtualMachine/sqlVirtualMachines, Microsoft.Network/virtualNetworks