General availability: Deployment enhancements for SQL Server on Azure Virtual Machines
Published date: February 02, 2022
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