Azure SQL Database default configurations are changing
Share
Services
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 9 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 programme 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 would prefer to continue using those 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](https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Ft-sql%2Fstatements%2Falter-database-transact-sql&data=02%7C01%7Cerhud%40microsoft.com%7C8c6cc696f7284fcb0ff508d7c145a8f2%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637190377234656812&sdata=2gwjrTSLf0rlvKwsAYSVlrzARxTSiKSSZlLKrnnSBT4%3D&reserved=0), [CLI](https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Fdb%3Fview%3Dazure-cli-latest%23az-sql-db-update&data=02%7C01%7Cerhud%40microsoft.com%7C8c6cc696f7284fcb0ff508d7c145a8f2%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637190377234656812&sdata=zTOHBaQRk7aLcgJ0IV50U4uSMFwjjYsdDfA5zZaIR%2BM%3D&reserved=0), [PowerShell](https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fazurerm.sql%2Fset-azurermsqldatabase%3Fview%3Dazurermps-6.13.0&data=02%7C01%7Cerhud%40microsoft.com%7C8c6cc696f7284fcb0ff508d7c145a8f2%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637190377234666807&sdata=gLGB0UnzxXQLke%2FUl7EcwXUuGahJNHeefTBaJO9fbmA%3D&reserved=0).
* Azure SQL Database
* Services
What else is happening at Microsoft Azure?
Read update
Services
Share
Read update
Services
Share
We’re retiring Azure Time Series Insights on 7 July 2024 – transition to Azure Data Explorer
May 31st, 2024
Services
Share