sku Name
Parameters
Specifies the name of the SKU used by the database. For example, GP_S_Gen5_2
,HS_Gen4_1
,BC_Gen5_2
, ElasticPool
, Basic
,S0
, P2
,DW100c
, DS100
. Changing this from the HyperScale service tier to another service tier will create a new resource.
Note: A full list of supported SKU names by region can be retrieved using the Azure CLI:
az sql db list-editions -l <region> -o table
Note: The defaultsku_name
value may differ between Azure locations depending on local availability of Gen4/Gen5 capacity. When databases are replicated using thecreation_source_database_id
property, the source (primary) database cannot have a higher SKU service tier than any secondary databases. When changing thesku_name
of a database having one or more secondary databases, this resource will first update any secondary databases as necessary. In such cases it's recommended to use the samesku_name
in your configuration for all related databases, as not doing so may cause an unresolvable diff during subsequent plans.