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

Key	Description
Free	Only one is allowed per subscription
Basic	Good for development and production environments with low CPU usage (5ms read & 10ms write) DTUs
Standard	Good 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
Premium	Good 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)

---