Performance-optimized storage configuration for SQL Server on Azure Virtual Machines
Posted on Wednesday, October 16, 2019
Performance-optimized storage configuration capabilities for virtual machines (VMs) registered with SQL VM Resource Provider are now available. This feature automates storage configuration according to performance best practices for SQL Server on Azure Virtual Machines through Azure portal or Azure quickstart templates when creating a SQL VM. Automated performance best practices include separating data and log files, cache configuration for Premium SSD, support for Temp DB on local disk, support for Ultra Disks to host data, log, or Temp DB files and database engine only images.