Share via

Microsoft.Sql instancePools 2022-08-01-preview

  • Article

Bicep resource definition

The instancePools 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/instancePools resource, add the following Bicep to your template.

resource symbolicname 'Microsoft.Sql/instancePools@2022-08-01-preview' = {
  location: 'string'
  name: 'string'
  properties: {
    licenseType: 'string'
    subnetId: 'string'
    vCores: int
  }
  sku: {
    capacity: int
    family: 'string'
    name: 'string'
    size: 'string'
    tier: 'string'
  }
  tags: {
    {customized property}: 'string'
  }
}

Property values

InstancePoolProperties

Name Description Value
licenseType The license type. Possible values are 'LicenseIncluded' (price for SQL license is included) and 'BasePrice' (without SQL license price). 'BasePrice'
'LicenseIncluded' (required)
subnetId Resource ID of the subnet to place this instance pool in. string (required)
vCores Count of vCores belonging to this instance pool. int (required)

Microsoft.Sql/instancePools

Name Description Value
location Resource location. string (required)
name The resource name string (required)
properties Resource properties. InstancePoolProperties
sku The name and tier of the SKU. 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 instancePools 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/instancePools resource, add the following JSON to your template.

{
  "type": "Microsoft.Sql/instancePools",
  "apiVersion": "2022-08-01-preview",
  "name": "string",
  "location": "string",
  "properties": {
    "licenseType": "string",
    "subnetId": "string",
    "vCores": "int"
  },
  "sku": {
    "capacity": "int",
    "family": "string",
    "name": "string",
    "size": "string",
    "tier": "string"
  },
  "tags": {
    "{customized property}": "string"
  }
}

Property values

InstancePoolProperties

Name Description Value
licenseType The license type. Possible values are 'LicenseIncluded' (price for SQL license is included) and 'BasePrice' (without SQL license price). 'BasePrice'
'LicenseIncluded' (required)
subnetId Resource ID of the subnet to place this instance pool in. string (required)
vCores Count of vCores belonging to this instance pool. int (required)

Microsoft.Sql/instancePools

Name Description Value
apiVersion The api version '2022-08-01-preview'
location Resource location. string (required)
name The resource name string (required)
properties Resource properties. InstancePoolProperties
sku The name and tier of the SKU. Sku
tags Resource tags Dictionary of tag names and values. See Tags in templates
type The resource type 'Microsoft.Sql/instancePools'

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

Terraform (AzAPI provider) resource definition

The instancePools 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/instancePools resource, add the following Terraform to your template.

resource "azapi_resource" "symbolicname" {
  type = "Microsoft.Sql/instancePools@2022-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 = {
      licenseType = "string"
      subnetId = "string"
      vCores = int
    }
  })
}

Property values

InstancePoolProperties

Name Description Value
licenseType The license type. Possible values are 'LicenseIncluded' (price for SQL license is included) and 'BasePrice' (without SQL license price). 'BasePrice'
'LicenseIncluded' (required)
subnetId Resource ID of the subnet to place this instance pool in. string (required)
vCores Count of vCores belonging to this instance pool. int (required)

Microsoft.Sql/instancePools

Name Description Value
location Resource location. string (required)
name The resource name string (required)
properties Resource properties. InstancePoolProperties
sku The name and tier of the SKU. Sku
tags Resource tags Dictionary of tag names and values.
type The resource type "Microsoft.Sql/instancePools@2022-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