General availability: Deployment enhancements for SQL Server on Azure Virtual Machines

Azure Updates

Discussionpowered by zap.ms

Published

Feb 2, 2022

Status

Launched

Timeline

  • February 2022
    General Availability

Product

SQL Server on Azure Virtual Machines

Tag

Features

Category

Compute
Databases

Description

Until now, Azure Marketplace images came with prebuilt SQL Server default configurations requiring you to configure your instance after the deployment of the image. Typically, this configuration is done on-premises during setup. We are offering a SQL Server setup-like experience where configuration of the instance is done during deployment of the image. We have included the following configuration options while setting up SQL Server through an Azure Marketplace image:

  • Move system databases to a data disk
  • Configure tempdb data and log files
  • Ability to change collation from default collation
  • Configure Maximum Degree of Parallelism
  • Configure Min Server Memory and Max Server Memory
  • Configure Optimize for Adhoc Workloads 

Learn more.