Microsoft.Sql instancePools 2023-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
- 2018-06-01-preview
Bicep resource definition
The instancePools 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/instancePools resource, add the following Bicep to your template.
resource symbolicname 'Microsoft.Sql/instancePools@2023-08-01-preview' = {
location: 'string'
name: 'string'
properties: {
licenseType: 'string'
maintenanceConfigurationId: '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) |
| maintenanceConfigurationId | Specifies maintenance configuration id to apply to this managed instance. | string |
| 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:
- 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/instancePools resource, add the following JSON to your template.
{
"type": "Microsoft.Sql/instancePools",
"apiVersion": "2023-08-01-preview",
"name": "string",
"location": "string",
"properties": {
"licenseType": "string",
"maintenanceConfigurationId": "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) |
| maintenanceConfigurationId | Specifies maintenance configuration id to apply to this managed instance. | string |
| 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 | '2023-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@2023-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"
maintenanceConfigurationId = "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) |
| maintenanceConfigurationId | Specifies maintenance configuration id to apply to this managed instance. | string |
| 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@2023-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 |
|---|