Microsoft.Sql servers/elasticPools 2021-08-01-preview
- Latest
- 2024-05-01-preview
- 2023-08-01-preview
- 2023-05-01-preview
- 2023-02-01-preview
- 2022-11-01-preview
- 2022-08-01-preview
- 2022-05-01-preview
- 2022-02-01-preview
- 2021-11-01
- 2021-11-01-preview
- 2021-08-01-preview
- 2021-05-01-preview
- 2021-02-01-preview
- 2020-11-01-preview
- 2020-08-01-preview
- 2020-02-02-preview
- 2017-10-01-preview
- 2014-04-01
Bicep resource definition
The servers/elasticPools resource type can be deployed with operations that target:
- Resource groups - See resource group deployment commands
For a list of changed properties in each API version, see change log.
Resource format
To create a Microsoft.Sql/servers/elasticPools resource, add the following Bicep to your template.
resource symbolicname 'Microsoft.Sql/servers/elasticPools@2021-08-01-preview' = {
parent: resourceSymbolicName
location: 'string'
name: 'string'
properties: {
highAvailabilityReplicaCount: int
licenseType: 'string'
maintenanceConfigurationId: 'string'
maxSizeBytes: int
perDatabaseSettings: {
maxCapacity: int
minCapacity: int
}
zoneRedundant: bool
}
sku: {
capacity: int
family: 'string'
name: 'string'
size: 'string'
tier: 'string'
}
tags: {
{customized property}: 'string'
}
}
Property values
ElasticPoolPerDatabaseSettings
Name | Description | Value |
---|---|---|
maxCapacity | The maximum capacity any one database can consume. | int |
minCapacity | The minimum capacity all databases are guaranteed. | int |
ElasticPoolProperties
Name | Description | Value |
---|---|---|
highAvailabilityReplicaCount | The number of secondary replicas associated with the elastic pool that are used to provide high availability. | int |
licenseType | The license type to apply for this elastic pool. | 'BasePrice' 'LicenseIncluded' |
maintenanceConfigurationId | Maintenance configuration id assigned to the elastic pool. This configuration defines the period when the maintenance updates will will occur. | string |
maxSizeBytes | The storage limit for the database elastic pool in bytes. | int |
perDatabaseSettings | The per database settings for the elastic pool. | ElasticPoolPerDatabaseSettings |
zoneRedundant | Whether or not this elastic pool is zone redundant, which means the replicas of this elastic pool will be spread across multiple availability zones. | bool |
Microsoft.Sql/servers/elasticPools
Name | Description | Value |
---|---|---|
location | Resource location. | string (required) |
name | The resource name | string (required) |
parent | In Bicep, you can specify the parent resource for a child resource. You only need to add this property when the child resource is declared outside of the parent resource. For more information, see Child resource outside parent resource. |
Symbolic name for resource of type: servers |
properties | Resource properties. | ElasticPoolProperties |
sku | The elastic pool SKU. The list of SKUs may vary by region and support offer. To determine the SKUs (including the SKU name, tier/edition, family, and capacity) that are available to your subscription in an Azure region, use the Capabilities_ListByLocation REST API or the following command:```azurecli az sql elastic-pool list-editions -l <location> -o table ```` |
Sku |
tags | Resource tags | Dictionary of tag names and values. See Tags in templates |
Sku
Name | Description | Value |
---|---|---|
capacity | Capacity of the particular SKU. | int |
family | If the service has different generations of hardware, for the same SKU, then that can be captured here. | string |
name | The name of the SKU, typically, a letter + Number code, e.g. P3. | string (required) |
size | Size of the particular SKU | string |
tier | The tier or edition of the particular SKU, e.g. Basic, Premium. | string |
TrackedResourceTags
Name | Description | Value |
---|
ARM template resource definition
The servers/elasticPools resource type can be deployed with operations that target:
- Resource groups - See resource group deployment commands
For a list of changed properties in each API version, see change log.
Resource format
To create a Microsoft.Sql/servers/elasticPools resource, add the following JSON to your template.
{
"type": "Microsoft.Sql/servers/elasticPools",
"apiVersion": "2021-08-01-preview",
"name": "string",
"location": "string",
"properties": {
"highAvailabilityReplicaCount": "int",
"licenseType": "string",
"maintenanceConfigurationId": "string",
"maxSizeBytes": "int",
"perDatabaseSettings": {
"maxCapacity": "int",
"minCapacity": "int"
},
"zoneRedundant": "bool"
},
"sku": {
"capacity": "int",
"family": "string",
"name": "string",
"size": "string",
"tier": "string"
},
"tags": {
"{customized property}": "string"
}
}
Property values
ElasticPoolPerDatabaseSettings
Name | Description | Value |
---|---|---|
maxCapacity | The maximum capacity any one database can consume. | int |
minCapacity | The minimum capacity all databases are guaranteed. | int |
ElasticPoolProperties
Name | Description | Value |
---|---|---|
highAvailabilityReplicaCount | The number of secondary replicas associated with the elastic pool that are used to provide high availability. | int |
licenseType | The license type to apply for this elastic pool. | 'BasePrice' 'LicenseIncluded' |
maintenanceConfigurationId | Maintenance configuration id assigned to the elastic pool. This configuration defines the period when the maintenance updates will will occur. | string |
maxSizeBytes | The storage limit for the database elastic pool in bytes. | int |
perDatabaseSettings | The per database settings for the elastic pool. | ElasticPoolPerDatabaseSettings |
zoneRedundant | Whether or not this elastic pool is zone redundant, which means the replicas of this elastic pool will be spread across multiple availability zones. | bool |
Microsoft.Sql/servers/elasticPools
Name | Description | Value |
---|---|---|
apiVersion | The api version | '2021-08-01-preview' |
location | Resource location. | string (required) |
name | The resource name | string (required) |
properties | Resource properties. | ElasticPoolProperties |
sku | The elastic pool SKU. The list of SKUs may vary by region and support offer. To determine the SKUs (including the SKU name, tier/edition, family, and capacity) that are available to your subscription in an Azure region, use the Capabilities_ListByLocation REST API or the following command:```azurecli az sql elastic-pool list-editions -l <location> -o table ```` |
Sku |
tags | Resource tags | Dictionary of tag names and values. See Tags in templates |
type | The resource type | 'Microsoft.Sql/servers/elasticPools' |
Sku
Name | Description | Value |
---|---|---|
capacity | Capacity of the particular SKU. | int |
family | If the service has different generations of hardware, for the same SKU, then that can be captured here. | string |
name | The name of the SKU, typically, a letter + Number code, e.g. P3. | string (required) |
size | Size of the particular SKU | string |
tier | The tier or edition of the particular SKU, e.g. Basic, Premium. | string |
TrackedResourceTags
Name | Description | Value |
---|
Quickstart templates
The following quickstart templates deploy this resource type.
Template | Description |
---|---|
Deploy a new SQL Elastic Pool |
This template allows you to deploy a new SQL Elastic Pool with its new associated SQL Server and new SQL Databases to assign to it. |
Terraform (AzAPI provider) resource definition
The servers/elasticPools resource type can be deployed with operations that target:
- Resource groups
For a list of changed properties in each API version, see change log.
Resource format
To create a Microsoft.Sql/servers/elasticPools resource, add the following Terraform to your template.
resource "azapi_resource" "symbolicname" {
type = "Microsoft.Sql/servers/elasticPools@2021-08-01-preview"
name = "string"
location = "string"
sku = {
capacity = int
family = "string"
name = "string"
size = "string"
tier = "string"
}
tags = {
{customized property} = "string"
}
body = jsonencode({
properties = {
highAvailabilityReplicaCount = int
licenseType = "string"
maintenanceConfigurationId = "string"
maxSizeBytes = int
perDatabaseSettings = {
maxCapacity = int
minCapacity = int
}
zoneRedundant = bool
}
})
}
Property values
ElasticPoolPerDatabaseSettings
Name | Description | Value |
---|---|---|
maxCapacity | The maximum capacity any one database can consume. | int |
minCapacity | The minimum capacity all databases are guaranteed. | int |
ElasticPoolProperties
Name | Description | Value |
---|---|---|
highAvailabilityReplicaCount | The number of secondary replicas associated with the elastic pool that are used to provide high availability. | int |
licenseType | The license type to apply for this elastic pool. | 'BasePrice' 'LicenseIncluded' |
maintenanceConfigurationId | Maintenance configuration id assigned to the elastic pool. This configuration defines the period when the maintenance updates will will occur. | string |
maxSizeBytes | The storage limit for the database elastic pool in bytes. | int |
perDatabaseSettings | The per database settings for the elastic pool. | ElasticPoolPerDatabaseSettings |
zoneRedundant | Whether or not this elastic pool is zone redundant, which means the replicas of this elastic pool will be spread across multiple availability zones. | bool |
Microsoft.Sql/servers/elasticPools
Name | Description | Value |
---|---|---|
location | Resource location. | string (required) |
name | The resource name | string (required) |
parent_id | The ID of the resource that is the parent for this resource. | ID for resource of type: servers |
properties | Resource properties. | ElasticPoolProperties |
sku | The elastic pool SKU. The list of SKUs may vary by region and support offer. To determine the SKUs (including the SKU name, tier/edition, family, and capacity) that are available to your subscription in an Azure region, use the Capabilities_ListByLocation REST API or the following command:```azurecli az sql elastic-pool list-editions -l <location> -o table ```` |
Sku |
tags | Resource tags | Dictionary of tag names and values. |
type | The resource type | "Microsoft.Sql/servers/elasticPools@2021-08-01-preview" |
Sku
Name | Description | Value |
---|---|---|
capacity | Capacity of the particular SKU. | int |
family | If the service has different generations of hardware, for the same SKU, then that can be captured here. | string |
name | The name of the SKU, typically, a letter + Number code, e.g. P3. | string (required) |
size | Size of the particular SKU | string |
tier | The tier or edition of the particular SKU, e.g. Basic, Premium. | string |
TrackedResourceTags
Name | Description | Value |
---|