Microsoft.Sql instancePools

Template format

To create a Microsoft.Sql/instancePools resource, add the following JSON to the resources section of your template.

{
  "name": "string",
  "type": "Microsoft.Sql/instancePools",
  "apiVersion": "2018-06-01-preview",
  "location": "string",
  "tags": {},
  "sku": {
    "name": "string",
    "tier": "string",
    "size": "string",
    "family": "string",
    "capacity": "integer"
  },
  "properties": {
    "subnetId": "string",
    "vCores": "integer",
    "licenseType": "string"
  }
}

Property values

The following tables describe the values you need to set in the schema.

Microsoft.Sql/instancePools object

Name Type Required Value
name string Yes The name of the instance pool to be created or updated.
type enum Yes Microsoft.Sql/instancePools
apiVersion enum Yes 2018-06-01-preview
location string Yes Resource location.
tags object No Resource tags.
sku object No The name and tier of the SKU. - Sku object
properties object Yes Resource properties. - InstancePoolProperties object

Sku object

Name Type Required Value
name string Yes The name of the SKU, typically, a letter + Number code, e.g. P3.
tier string No The tier or edition of the particular SKU, e.g. Basic, Premium.
size string No Size of the particular SKU
family string No If the service has different generations of hardware, for the same SKU, then that can be captured here.
capacity integer No Capacity of the particular SKU.

InstancePoolProperties object

Name Type Required Value
subnetId string Yes Resource ID of the subnet to place this instance pool in.
vCores integer Yes Count of vCores belonging to this instance pool.
licenseType enum Yes The license type. Possible values are 'LicenseIncluded' (price for SQL license is included) and 'BasePrice' (without SQL license price). - LicenseIncluded or BasePrice