Share via

Microsoft.Sql servers/elasticPools 2020-02-02-preview

  • Article

Bicep resource definition

The servers/elasticPools resource type can be deployed with operations that target:

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@2020-02-02-preview' = {
  parent: resourceSymbolicName
  location: 'string'
  name: 'string'
  properties: {
    licenseType: '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
licenseType The license type to apply for this elastic pool. 'BasePrice'
'LicenseIncluded'
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:

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": "2020-02-02-preview",
  "name": "string",
  "location": "string",
  "properties": {
    "licenseType": "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
licenseType The license type to apply for this elastic pool. 'BasePrice'
'LicenseIncluded'
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 '2020-02-02-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

Deploy to Azure		 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@2020-02-02-preview"
  name = "string"
  location = "string"
  sku = {
    capacity = int
    family = "string"
    name = "string"
    size = "string"
    tier = "string"
  }
  tags = {
    {customized property} = "string"
  }
  body = jsonencode({
    properties = {
      licenseType = "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
licenseType The license type to apply for this elastic pool. 'BasePrice'
'LicenseIncluded'
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@2020-02-02-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