SQL Database

Overview

{
    "sql_database": {
        "name": "sql-db-lp-test-{env}",
        "sku": { "name": "Standard", "capacity": "10"},
        "@sql_server_name": "sql-lp-test-{env}",

        "zone_redundant": true,
        "backup_redundancy": "Local",
        "size_in_bytes": 1073741824,
        "external": true,
        "resource_group_name": "my-rg-name",
        "tags": { "example": "S0" }
    }
}

SQL Server Database Reference

KeyTypeDescription
name (required)stringThe name of the SQL Server Database(see how to name)
sku (required)object of skuThe SKU of the database
@sql_server_namestringThe name of the SQL Server
zone_redundantboolWhether or not the database is zone redundant (defaults to false)
backup_redundancystringThe redundancy of the database (defaults to Local)
size_in_bytesintThe maximum size of the database in bytes (defaults to 1GB)
externalboolA reference to an existing SQL Server Database (defaults to false)
resource_group_namestringThe name of the resource group where the resource is located, only with external resources (defaults to the resource group of the deployment)
tagsobjectAdditional tags for the resource (defaults to no additional tags)

SKU

KeyTypeDescription
name (required)string of nameThe name of the SKU
capacity (required)intCapacity of the particular SKU

Name

KeyDescription
FreeOnly one is allowed per subscription
BasicGood for development and production environments with low CPU usage (5ms read & 10ms write) DTUs
StandardGood for development and production environments with low, medium and high CPU usage (5ms read & 10ms write), allows the usage of columnstore indexing Standard S3 or higher 3000 DTUs
PremiumGood for development and production environments with low, medium and high CPU usage (2ms read/write), allows the usage of columnstore indexing 4000 DTUs
GPGen5(See detailed information about this tier here)
GPDC(See detailed information about this tier here)
GPsGen5(See detailed information about this tier here)
GPFsv2(See detailed information about this tier here)