Azure SQL Database default configurations are changing
Published date: 12 March, 2020
Azure SQL Database now has the latest Gen 5 hardware in place to ensure optimal service performance. As a result, the default database configurations and the default elastic pool configurations are being changed for all new Azure SQL databases.
Beginning 9th March 2020, these will be the default configurations for new databases and elastic pools:
-
Databases
-
General purpose tier—provisioned with 2 vCores on Gen 5 hardware
-
Business critical tier—provisioned with 2 vCores on Gen 5 hardware
-
-
Elastic pools
-
General purpose tier—provisioned with 2 vCores on Gen 5 hardware
-
Business critical tier—provisioned with 4 vCores on Gen 5 hardware
-
Customers engaging in the free trial program will have access to databases and elastic pools on the general purpose tier, provisioned with 2 vCores on Gen 5 hardware.
If you have existing databases and elastic pools on Gen 4 hardware and prefer to continue using that for new ones, select Gen 4 hardware options from within the Azure portal or via scripts. If you rely upon scripts to automate the creation of new databases or pools, update them to create the database with your preferred hardware options.
Read the documentation for sample scripts: T-SQL, CLI, PowerShell.