SQL Elastic Pool
Overview
{
"sql_elastic_pool": {
"name": "sql-pool-lp-test-{env}",
"sku": { "name": "Standard", "capacity": "10" },
"@sql_server_name": "sql-lp-test-{env}",
"zone_redundant": true,
"size_in_bytes": 1073741824,
"database_settings": { "min_capacity": 0, "max_capacity": 2 },
"location": "northeurope",
"external": false,
"resource_group_name": "my-rg-name",
"tags": { "example": "S0" }
}
}
SQL Elastic Pool Reference
| Key | Type | Description |
|---|
name (required) | string | The name of the SQL Elastic Pool(see how to name) |
sku (required) | object of sku | The SKU of the Elastic Pool |
@sql_server_name (required) | string | The name of the SQL Server |
zone_redundant | bool | Whether or not the Elastic Pool is zone redundant (defaults to false) |
size_in_bytes | int | The maximum size of the database in bytes (defaults to 1GB) |
database_settings | int | The per database settings for the elastic pool |
location | string | Resource Location (defaults to the resource group location) |
external | bool | A reference to an existing SQL Elastic Pool (defaults to false) |
resource_group_name | string | The name of the resource group where the resource is located, only with external resources (defaults to the resource group of the deployment) |
tags | object | Additional tags for the resource (defaults to no additional tags) |
SKU
| Key | Type | Description |
|---|
name (required) | string of name | The name of the SKU |
capacity (required) | int | Capacity of the particular SKU |
Name