SQL VM Performance Optimized Storage Settings on UltraSSD

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

Before deploying the template you must have the following

  1. Virtual Network and Subnet in same location
  2. Follow this this documentation to determine your availability zone.

Deploy To Azure Visualize

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

Note

  • 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.