SQL VM Performance Optimized Storage Settings on UltraSSD
Before deploying the template you must have the following
- Virtual Network and Subnet in same location
- Follow this this documentation to determine your availability zone.
Tags: Azure, SQL, VirtualMachine, Performance, StorageConfiguration, UltraSSD, Microsoft.Compute/disks, Microsoft.Network/publicIpAddresses, Microsoft.Network/networkSecurityGroups, Microsoft.Network/networkInterfaces, Microsoft.Compute/virtualMachines, Microsoft.SqlVirtualMachine/SqlVirtualMachines, Microsoft.Network/virtualNetworks
Solution overview and deployed resources
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 files. Ultra SSD will be used for SQL Log files and the user will specify the disk size and expected maximum IOPS and throughput. TempDb will use the local SSD and a scheduled task will be used to create the TempDB folder structure and start the default SQL Instance if the local SSD is reset during VM restart.
SQL Server will use Windows Authentication.
The following resources will be 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
- An Ultra SSD Disk for SQL Log
- A Sql Virtual Machine resource attached to the VM
- This VM will have Ultra SSD compatibility enabled and there will be a reservation charge if no Ultra SSD Disk is attached to the VM.