SQL Server VM with performance optimized storage settings
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