Microsoft.Sql instancePools 2020-02-02-preview

The instancePools resource type can be deployed to: Resource groups.

To learn about resource group deployments, see Bicep or ARM template.

Template format

To create a Microsoft.Sql/instancePools resource, add the following Bicep or JSON to your template.

resource symbolicname 'Microsoft.Sql/instancePools@2020-02-02-preview' = {
  name: 'string'
  location: 'string'
  tags: {
    tagName1: 'tagValue1'
    tagName2: 'tagValue2'
  sku: {
    capacity: int
    family: 'string'
    name: 'string'
    size: 'string'
    tier: 'string'
  properties: {
    licenseType: 'string'
    subnetId: 'string'
    vCores: int

Property values


Name Description Value
type The resource type

For Bicep, set this value in the resource declaration.
apiVersion The resource api version

For Bicep, set this value in the resource declaration.
name The resource name string (required)
location Resource location. string (required)
tags Resource tags. Dictionary of tag names and values. See Tags in templates
sku An ARM Resource SKU. Sku
properties Properties of an instance pool. 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'
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)


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