Maintained with ☕️ by
IcePanel logo

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