Performance-optimized storage configuration for SQL Server on Azure Virtual Machines

Azure Updates

Discussionpowered by zap.ms

Published

Oct 16, 2019

Status

Launched

Timeline

  • October 2019
    General Availability

Product

Virtual Machines

Tag

Features

Category

Compute

Description

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.

Read more about each automated performance best practice.

Learn more