Capabilities - List By Location
Gets the subscription capabilities available for the specified location.
GET https://management.azure.com/subscriptions/{subscriptionId}/providers/Microsoft.Sql/locations/{locationName}/capabilities?api-version=2021-11-01GET https://management.azure.com/subscriptions/{subscriptionId}/providers/Microsoft.Sql/locations/{locationName}/capabilities?include={include}&api-version=2021-11-01URI Parameters
| Name | In | Required | Type | Description |
|---|---|---|---|---|
|
location
|
path | True |
string |
The location name whose capabilities are retrieved. |
|
subscription
|
path | True |
string |
The subscription ID that identifies an Azure subscription. |
|
api-version
|
query | True |
string |
The API version to use for the request. |
|
include
|
query |
If specified, restricts the response to only include the selected item. |
Responses
| Name | Type | Description |
|---|---|---|
| 200 OK |
Successfully retrieved the subscription location capabilities. |
|
| Other Status Codes |
*** Error Responses: ***
|
Examples
List subscription capabilities in the given location.
Sample request
Sample response
{
"name": "East US",
"supportedServerVersions": [
{
"name": "12.0",
"supportedEditions": [
{
"name": "Hyperscale",
"supportedServiceLevelObjectives": [
{
"id": "9380cd0e-b025-4e9d-829c-c1918c1614bb",
"name": "HS_Gen4_1",
"performanceLevel": {
"value": 1,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen4",
"tier": "Hyperscale",
"family": "Gen4",
"capacity": 1
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "34497c3f-24b9-4cee-968d-6e5e854670fe",
"name": "HS_Gen4_2",
"performanceLevel": {
"value": 2,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen4",
"tier": "Hyperscale",
"family": "Gen4",
"capacity": 2
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "a420d2b2-ca32-4152-b1c6-dd8d4d9fd734",
"name": "HS_Gen5_2",
"performanceLevel": {
"value": 2,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 2
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Default"
},
{
"id": "5de845d2-2055-428c-b507-94131358cdd7",
"name": "HS_Gen4_3",
"performanceLevel": {
"value": 3,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen4",
"tier": "Hyperscale",
"family": "Gen4",
"capacity": 3
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "d060b874-21f3-47b0-a9bd-a1a737cfcc6e",
"name": "HS_Gen4_4",
"performanceLevel": {
"value": 4,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen4",
"tier": "Hyperscale",
"family": "Gen4",
"capacity": 4
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "60dba88b-2dfa-4123-be57-bd0dbfd92a72",
"name": "HS_Gen5_4",
"performanceLevel": {
"value": 4,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 4
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "925a0916-15fb-4764-aa76-533d97f2d782",
"name": "HS_Gen4_5",
"performanceLevel": {
"value": 5,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen4",
"tier": "Hyperscale",
"family": "Gen4",
"capacity": 5
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "d7aa11c2-e4c7-442a-962e-308b371f5ec1",
"name": "HS_Gen4_6",
"performanceLevel": {
"value": 6,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen4",
"tier": "Hyperscale",
"family": "Gen4",
"capacity": 6
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "b9c594ec-a3fe-4bfe-808d-a595410d0a07",
"name": "HS_Gen5_6",
"performanceLevel": {
"value": 6,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 6
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "d77eef57-6c00-4003-b140-822509b8736a",
"name": "HS_Gen4_7",
"performanceLevel": {
"value": 7,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen4",
"tier": "Hyperscale",
"family": "Gen4",
"capacity": 7
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "694bf389-7cb2-4461-8fa2-0b06d8438315",
"name": "HS_Gen4_8",
"performanceLevel": {
"value": 8,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen4",
"tier": "Hyperscale",
"family": "Gen4",
"capacity": 8
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "efdfac5f-3f8e-4500-95b1-684c07349860",
"name": "HS_Gen5_8",
"performanceLevel": {
"value": 8,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 8
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "554ea52a-9ecc-4d87-bbc7-1e257705da3f",
"name": "HS_Gen4_9",
"performanceLevel": {
"value": 9,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen4",
"tier": "Hyperscale",
"family": "Gen4",
"capacity": 9
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "576f3f38-b950-4eaa-b74e-33d831193441",
"name": "HS_Gen4_10",
"performanceLevel": {
"value": 10,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen4",
"tier": "Hyperscale",
"family": "Gen4",
"capacity": 10
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "69697c3a-1946-4eb8-a5a4-a269168dde27",
"name": "HS_Gen5_10",
"performanceLevel": {
"value": 10,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 10
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "1bee9dc8-68b4-44df-b870-8ab0e4d71e94",
"name": "HS_Gen5_12",
"performanceLevel": {
"value": 12,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 12
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "07a8341d-c0b2-4000-bc7a-5b4dae2ad210",
"name": "HS_Gen5_14",
"performanceLevel": {
"value": 14,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 14
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "7fc1f700-a45d-499e-901f-2a00645c54db",
"name": "HS_Gen4_16",
"performanceLevel": {
"value": 16,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen4",
"tier": "Hyperscale",
"family": "Gen4",
"capacity": 16
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "6b56f70b-52e5-44ba-8cd5-4f63d224b206",
"name": "HS_Gen5_16",
"performanceLevel": {
"value": 16,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 16
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "ba0029f2-3ff4-4ef6-9e65-e8f77b5dd1e2",
"name": "HS_Gen5_18",
"performanceLevel": {
"value": 18,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 18
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "f1b2a082-f622-4fb8-bbef-e74deac3ec89",
"name": "HS_Gen5_20",
"performanceLevel": {
"value": 20,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 20
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "f016d419-a031-4b93-ab62-7f3d2a789376",
"name": "HS_Gen4_24",
"performanceLevel": {
"value": 24,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen4",
"tier": "Hyperscale",
"family": "Gen4",
"capacity": 24
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "222bc0ee-e195-4bbc-be05-3b849c3a8195",
"name": "HS_Gen5_24",
"performanceLevel": {
"value": 24,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 24
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "05366cca-cc70-486e-a697-bb3fab877f75",
"name": "HS_Gen5_32",
"performanceLevel": {
"value": 32,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 32
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "32542ef7-124d-4e66-8b41-9c6c0ab963c2",
"name": "HS_Gen5_40",
"performanceLevel": {
"value": 40,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 40
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"id": "6509db45-febe-44dd-a079-35f11d477984",
"name": "HS_Gen5_80",
"performanceLevel": {
"value": 80,
"unit": "VCores"
},
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 80
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"zoneRedundant": false,
"computeModel": "Provisioned",
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
}
],
"status": "Available"
}
],
"zoneRedundant": false,
"readScale": {
"maxNumberOfReplicas": 4
},
"supportedStorageCapabilities": [
{
"storageAccountType": "GRS",
"status": "Default"
},
{
"storageAccountType": "LRS",
"status": "Available"
},
{
"storageAccountType": "ZRS",
"status": "Available",
"reason": "ZRS is available in multi-az regions"
},
{
"storageAccountType": "GZRS",
"status": "Available",
"reason": "GZRS is available in multi-az regions"
}
],
"status": "Available"
}
],
"supportedElasticPoolEditions": [
{
"name": "BusinessCritical",
"supportedElasticPoolPerformanceLevels": [
{
"performanceLevel": {
"value": 3,
"unit": "VCores"
},
"sku": {
"name": "BC_Gen4",
"tier": "BusinessCritical",
"family": "Gen4",
"capacity": 3
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"maxDatabaseCount": 100,
"supportedMaxSizes": [
{
"minValue": {
"limit": 1024,
"unit": "Megabytes"
},
"maxValue": {
"limit": 31744,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 1024,
"unit": "Megabytes"
},
"logSize": {
"limit": 30,
"unit": "Percent"
},
"status": "Available"
},
{
"minValue": {
"limit": 32768,
"unit": "Megabytes"
},
"maxValue": {
"limit": 32768,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 0,
"unit": "Megabytes"
},
"logSize": {
"limit": 30,
"unit": "Percent"
},
"status": "Default"
},
{
"minValue": {
"limit": 33792,
"unit": "Megabytes"
},
"maxValue": {
"limit": 1048576,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 1024,
"unit": "Megabytes"
},
"logSize": {
"limit": 30,
"unit": "Percent"
},
"status": "Available"
}
],
"supportedPerDatabaseMaxSizes": [
{
"minValue": {
"limit": 1024,
"unit": "Megabytes"
},
"maxValue": {
"limit": 31744,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 1024,
"unit": "Megabytes"
},
"status": "Available"
},
{
"minValue": {
"limit": 32768,
"unit": "Megabytes"
},
"maxValue": {
"limit": 32768,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 0,
"unit": "Megabytes"
},
"status": "Default"
},
{
"minValue": {
"limit": 33792,
"unit": "Megabytes"
},
"maxValue": {
"limit": 1048576,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 1024,
"unit": "Megabytes"
},
"status": "Available"
}
],
"supportedPerDatabaseMaxPerformanceLevels": [
{
"limit": 0.25,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 0.25,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 0.5,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 0.25,
"unit": "VCores",
"status": "Available"
},
{
"limit": 0.5,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 1,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 0.25,
"unit": "VCores",
"status": "Available"
},
{
"limit": 0.5,
"unit": "VCores",
"status": "Available"
},
{
"limit": 1,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 2,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 0.25,
"unit": "VCores",
"status": "Available"
},
{
"limit": 0.5,
"unit": "VCores",
"status": "Available"
},
{
"limit": 1,
"unit": "VCores",
"status": "Available"
},
{
"limit": 2,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 3,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 0.25,
"unit": "VCores",
"status": "Available"
},
{
"limit": 0.5,
"unit": "VCores",
"status": "Available"
},
{
"limit": 1,
"unit": "VCores",
"status": "Available"
},
{
"limit": 2,
"unit": "VCores",
"status": "Available"
},
{
"limit": 3,
"unit": "VCores",
"status": "Available"
}
],
"status": "Default"
}
],
"zoneRedundant": false,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
},
{
"name": "SQL_EastUS_DB_1",
"status": "Available",
"zoneRedundant": false
},
{
"name": "SQL_EastUS_DB_2",
"status": "Available",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"performanceLevel": {
"value": 12,
"unit": "VCores"
},
"sku": {
"name": "BC_Gen5",
"tier": "BusinessCritical",
"family": "Gen5",
"capacity": 12
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"maxDatabaseCount": 100,
"supportedMaxSizes": [
{
"minValue": {
"limit": 1024,
"unit": "Megabytes"
},
"maxValue": {
"limit": 31744,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 1024,
"unit": "Megabytes"
},
"logSize": {
"limit": 30,
"unit": "Percent"
},
"status": "Available"
},
{
"minValue": {
"limit": 32768,
"unit": "Megabytes"
},
"maxValue": {
"limit": 32768,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 0,
"unit": "Megabytes"
},
"logSize": {
"limit": 30,
"unit": "Percent"
},
"status": "Default"
},
{
"minValue": {
"limit": 33792,
"unit": "Megabytes"
},
"maxValue": {
"limit": 3144704,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 1024,
"unit": "Megabytes"
},
"logSize": {
"limit": 30,
"unit": "Percent"
},
"status": "Available"
},
{
"minValue": {
"limit": 3145728,
"unit": "Megabytes"
},
"maxValue": {
"limit": 3145728,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 0,
"unit": "Megabytes"
},
"logSize": {
"limit": 1048576,
"unit": "Megabytes"
},
"status": "Available"
}
],
"supportedPerDatabaseMaxSizes": [
{
"minValue": {
"limit": 1024,
"unit": "Megabytes"
},
"maxValue": {
"limit": 31744,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 1024,
"unit": "Megabytes"
},
"status": "Available"
},
{
"minValue": {
"limit": 32768,
"unit": "Megabytes"
},
"maxValue": {
"limit": 32768,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 0,
"unit": "Megabytes"
},
"status": "Default"
},
{
"minValue": {
"limit": 33792,
"unit": "Megabytes"
},
"maxValue": {
"limit": 3144704,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 1024,
"unit": "Megabytes"
},
"status": "Available"
},
{
"minValue": {
"limit": 3145728,
"unit": "Megabytes"
},
"maxValue": {
"limit": 3145728,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 0,
"unit": "Megabytes"
},
"status": "Available"
}
],
"supportedPerDatabaseMaxPerformanceLevels": [
{
"limit": 0.25,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 0.25,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 0.5,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 0.25,
"unit": "VCores",
"status": "Available"
},
{
"limit": 0.5,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 1,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 0.25,
"unit": "VCores",
"status": "Available"
},
{
"limit": 0.5,
"unit": "VCores",
"status": "Available"
},
{
"limit": 1,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 2,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 0.25,
"unit": "VCores",
"status": "Available"
},
{
"limit": 0.5,
"unit": "VCores",
"status": "Available"
},
{
"limit": 1,
"unit": "VCores",
"status": "Available"
},
{
"limit": 2,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 4,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 0.25,
"unit": "VCores",
"status": "Available"
},
{
"limit": 0.5,
"unit": "VCores",
"status": "Available"
},
{
"limit": 1,
"unit": "VCores",
"status": "Available"
},
{
"limit": 2,
"unit": "VCores",
"status": "Available"
},
{
"limit": 4,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 6,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 0.25,
"unit": "VCores",
"status": "Available"
},
{
"limit": 0.5,
"unit": "VCores",
"status": "Available"
},
{
"limit": 1,
"unit": "VCores",
"status": "Available"
},
{
"limit": 2,
"unit": "VCores",
"status": "Available"
},
{
"limit": 4,
"unit": "VCores",
"status": "Available"
},
{
"limit": 6,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 8,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 0.25,
"unit": "VCores",
"status": "Available"
},
{
"limit": 0.5,
"unit": "VCores",
"status": "Available"
},
{
"limit": 1,
"unit": "VCores",
"status": "Available"
},
{
"limit": 2,
"unit": "VCores",
"status": "Available"
},
{
"limit": 4,
"unit": "VCores",
"status": "Available"
},
{
"limit": 6,
"unit": "VCores",
"status": "Available"
},
{
"limit": 8,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 10,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 0.25,
"unit": "VCores",
"status": "Available"
},
{
"limit": 0.5,
"unit": "VCores",
"status": "Available"
},
{
"limit": 1,
"unit": "VCores",
"status": "Available"
},
{
"limit": 2,
"unit": "VCores",
"status": "Available"
},
{
"limit": 4,
"unit": "VCores",
"status": "Available"
},
{
"limit": 6,
"unit": "VCores",
"status": "Available"
},
{
"limit": 8,
"unit": "VCores",
"status": "Available"
},
{
"limit": 10,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 12,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 0.25,
"unit": "VCores",
"status": "Available"
},
{
"limit": 0.5,
"unit": "VCores",
"status": "Available"
},
{
"limit": 1,
"unit": "VCores",
"status": "Available"
},
{
"limit": 2,
"unit": "VCores",
"status": "Available"
},
{
"limit": 4,
"unit": "VCores",
"status": "Available"
},
{
"limit": 6,
"unit": "VCores",
"status": "Available"
},
{
"limit": 8,
"unit": "VCores",
"status": "Available"
},
{
"limit": 10,
"unit": "VCores",
"status": "Available"
},
{
"limit": 12,
"unit": "VCores",
"status": "Available"
}
],
"status": "Default"
}
],
"zoneRedundant": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
},
{
"name": "SQL_EastUS_DB_1",
"status": "Available",
"zoneRedundant": false
},
{
"name": "SQL_EastUS_DB_2",
"status": "Available",
"zoneRedundant": false
}
],
"status": "Available"
},
{
"performanceLevel": {
"value": 128,
"unit": "VCores"
},
"sku": {
"name": "BC_M",
"tier": "BusinessCritical",
"family": "M",
"capacity": 128
},
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"maxDatabaseCount": 100,
"supportedMaxSizes": [
{
"minValue": {
"limit": 1024,
"unit": "Megabytes"
},
"maxValue": {
"limit": 31744,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 1024,
"unit": "Megabytes"
},
"logSize": {
"limit": 30,
"unit": "Percent"
},
"status": "Available"
},
{
"minValue": {
"limit": 32768,
"unit": "Megabytes"
},
"maxValue": {
"limit": 32768,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 0,
"unit": "Megabytes"
},
"logSize": {
"limit": 30,
"unit": "Percent"
},
"status": "Default"
},
{
"minValue": {
"limit": 33792,
"unit": "Megabytes"
},
"maxValue": {
"limit": 3144704,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 1024,
"unit": "Megabytes"
},
"logSize": {
"limit": 30,
"unit": "Percent"
},
"status": "Available"
},
{
"minValue": {
"limit": 3145728,
"unit": "Megabytes"
},
"maxValue": {
"limit": 4194304,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 1024,
"unit": "Megabytes"
},
"logSize": {
"limit": 1048576,
"unit": "Megabytes"
},
"status": "Available"
}
],
"supportedPerDatabaseMaxSizes": [
{
"minValue": {
"limit": 1024,
"unit": "Megabytes"
},
"maxValue": {
"limit": 31744,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 1024,
"unit": "Megabytes"
},
"status": "Available"
},
{
"minValue": {
"limit": 32768,
"unit": "Megabytes"
},
"maxValue": {
"limit": 32768,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 0,
"unit": "Megabytes"
},
"status": "Default"
},
{
"minValue": {
"limit": 33792,
"unit": "Megabytes"
},
"maxValue": {
"limit": 3144704,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 1024,
"unit": "Megabytes"
},
"status": "Available"
},
{
"minValue": {
"limit": 3145728,
"unit": "Megabytes"
},
"maxValue": {
"limit": 4194304,
"unit": "Megabytes"
},
"scaleSize": {
"limit": 1024,
"unit": "Megabytes"
},
"status": "Available"
}
],
"supportedPerDatabaseMaxPerformanceLevels": [
{
"limit": 8,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 8,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 10,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 8,
"unit": "VCores",
"status": "Available"
},
{
"limit": 10,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 12,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 8,
"unit": "VCores",
"status": "Available"
},
{
"limit": 10,
"unit": "VCores",
"status": "Available"
},
{
"limit": 12,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 14,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 8,
"unit": "VCores",
"status": "Available"
},
{
"limit": 10,
"unit": "VCores",
"status": "Available"
},
{
"limit": 12,
"unit": "VCores",
"status": "Available"
},
{
"limit": 14,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 16,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 8,
"unit": "VCores",
"status": "Available"
},
{
"limit": 10,
"unit": "VCores",
"status": "Available"
},
{
"limit": 12,
"unit": "VCores",
"status": "Available"
},
{
"limit": 14,
"unit": "VCores",
"status": "Available"
},
{
"limit": 16,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 18,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 8,
"unit": "VCores",
"status": "Available"
},
{
"limit": 10,
"unit": "VCores",
"status": "Available"
},
{
"limit": 12,
"unit": "VCores",
"status": "Available"
},
{
"limit": 14,
"unit": "VCores",
"status": "Available"
},
{
"limit": 16,
"unit": "VCores",
"status": "Available"
},
{
"limit": 18,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 20,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 8,
"unit": "VCores",
"status": "Available"
},
{
"limit": 10,
"unit": "VCores",
"status": "Available"
},
{
"limit": 12,
"unit": "VCores",
"status": "Available"
},
{
"limit": 14,
"unit": "VCores",
"status": "Available"
},
{
"limit": 16,
"unit": "VCores",
"status": "Available"
},
{
"limit": 18,
"unit": "VCores",
"status": "Available"
},
{
"limit": 20,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 24,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 8,
"unit": "VCores",
"status": "Available"
},
{
"limit": 10,
"unit": "VCores",
"status": "Available"
},
{
"limit": 12,
"unit": "VCores",
"status": "Available"
},
{
"limit": 14,
"unit": "VCores",
"status": "Available"
},
{
"limit": 16,
"unit": "VCores",
"status": "Available"
},
{
"limit": 18,
"unit": "VCores",
"status": "Available"
},
{
"limit": 20,
"unit": "VCores",
"status": "Available"
},
{
"limit": 24,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 32,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 8,
"unit": "VCores",
"status": "Available"
},
{
"limit": 10,
"unit": "VCores",
"status": "Available"
},
{
"limit": 12,
"unit": "VCores",
"status": "Available"
},
{
"limit": 14,
"unit": "VCores",
"status": "Available"
},
{
"limit": 16,
"unit": "VCores",
"status": "Available"
},
{
"limit": 18,
"unit": "VCores",
"status": "Available"
},
{
"limit": 20,
"unit": "VCores",
"status": "Available"
},
{
"limit": 24,
"unit": "VCores",
"status": "Available"
},
{
"limit": 32,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 40,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 8,
"unit": "VCores",
"status": "Available"
},
{
"limit": 10,
"unit": "VCores",
"status": "Available"
},
{
"limit": 12,
"unit": "VCores",
"status": "Available"
},
{
"limit": 14,
"unit": "VCores",
"status": "Available"
},
{
"limit": 16,
"unit": "VCores",
"status": "Available"
},
{
"limit": 18,
"unit": "VCores",
"status": "Available"
},
{
"limit": 20,
"unit": "VCores",
"status": "Available"
},
{
"limit": 24,
"unit": "VCores",
"status": "Available"
},
{
"limit": 32,
"unit": "VCores",
"status": "Available"
},
{
"limit": 40,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 64,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 8,
"unit": "VCores",
"status": "Available"
},
{
"limit": 10,
"unit": "VCores",
"status": "Available"
},
{
"limit": 12,
"unit": "VCores",
"status": "Available"
},
{
"limit": 14,
"unit": "VCores",
"status": "Available"
},
{
"limit": 16,
"unit": "VCores",
"status": "Available"
},
{
"limit": 18,
"unit": "VCores",
"status": "Available"
},
{
"limit": 20,
"unit": "VCores",
"status": "Available"
},
{
"limit": 24,
"unit": "VCores",
"status": "Available"
},
{
"limit": 32,
"unit": "VCores",
"status": "Available"
},
{
"limit": 40,
"unit": "VCores",
"status": "Available"
},
{
"limit": 64,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 80,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 8,
"unit": "VCores",
"status": "Available"
},
{
"limit": 10,
"unit": "VCores",
"status": "Available"
},
{
"limit": 12,
"unit": "VCores",
"status": "Available"
},
{
"limit": 14,
"unit": "VCores",
"status": "Available"
},
{
"limit": 16,
"unit": "VCores",
"status": "Available"
},
{
"limit": 18,
"unit": "VCores",
"status": "Available"
},
{
"limit": 20,
"unit": "VCores",
"status": "Available"
},
{
"limit": 24,
"unit": "VCores",
"status": "Available"
},
{
"limit": 32,
"unit": "VCores",
"status": "Available"
},
{
"limit": 40,
"unit": "VCores",
"status": "Available"
},
{
"limit": 64,
"unit": "VCores",
"status": "Available"
},
{
"limit": 80,
"unit": "VCores",
"status": "Available"
}
],
"status": "Available"
},
{
"limit": 128,
"unit": "VCores",
"supportedPerDatabaseMinPerformanceLevels": [
{
"limit": 0,
"unit": "VCores",
"status": "Default"
},
{
"limit": 8,
"unit": "VCores",
"status": "Available"
},
{
"limit": 10,
"unit": "VCores",
"status": "Available"
},
{
"limit": 12,
"unit": "VCores",
"status": "Available"
},
{
"limit": 14,
"unit": "VCores",
"status": "Available"
},
{
"limit": 16,
"unit": "VCores",
"status": "Available"
},
{
"limit": 18,
"unit": "VCores",
"status": "Available"
},
{
"limit": 20,
"unit": "VCores",
"status": "Available"
},
{
"limit": 24,
"unit": "VCores",
"status": "Available"
},
{
"limit": 32,
"unit": "VCores",
"status": "Available"
},
{
"limit": 40,
"unit": "VCores",
"status": "Available"
},
{
"limit": 64,
"unit": "VCores",
"status": "Available"
},
{
"limit": 80,
"unit": "VCores",
"status": "Available"
},
{
"limit": 128,
"unit": "VCores",
"status": "Available"
}
],
"status": "Default"
}
],
"zoneRedundant": false,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default",
"zoneRedundant": false
},
{
"name": "SQL_EastUS_DB_1",
"status": "Available",
"zoneRedundant": false
},
{
"name": "SQL_EastUS_DB_2",
"status": "Available",
"zoneRedundant": false
}
],
"status": "Available"
}
],
"zoneRedundant": false,
"status": "Available"
}
],
"status": "Default"
}
],
"supportedManagedInstanceVersions": [
{
"name": "12.0",
"supportedEditions": [
{
"name": "GeneralPurpose",
"supportedFamilies": [
{
"name": "Gen4",
"sku": "GP_Gen4",
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"supportedVcoresValues": [
{
"name": "8",
"value": 8,
"includedMaxSize": {
"limit": 262144,
"unit": "Megabytes"
},
"supportedStorageSizes": [
{
"minValue": {
"limit": 32,
"unit": "Gigabytes"
},
"maxValue": {
"limit": 8,
"unit": "Terabytes"
},
"scaleSize": {
"limit": 32,
"unit": "Gigabytes"
},
"status": "Available"
}
],
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
},
{
"name": "SQL_EastUS_MI_1",
"status": "Available"
},
{
"name": "SQL_EastUS_MI_2",
"status": "Available"
}
],
"status": "Default"
},
{
"name": "16",
"value": 16,
"includedMaxSize": {
"limit": 262144,
"unit": "Megabytes"
},
"supportedStorageSizes": [
{
"minValue": {
"limit": 32,
"unit": "Gigabytes"
},
"maxValue": {
"limit": 8,
"unit": "Terabytes"
},
"scaleSize": {
"limit": 32,
"unit": "Gigabytes"
},
"status": "Available"
}
],
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
},
{
"name": "SQL_EastUS_MI_1",
"status": "Available"
},
{
"name": "SQL_EastUS_MI_2",
"status": "Available"
}
],
"status": "Available"
},
{
"name": "24",
"value": 24,
"includedMaxSize": {
"limit": 262144,
"unit": "Megabytes"
},
"supportedStorageSizes": [
{
"minValue": {
"limit": 32,
"unit": "Gigabytes"
},
"maxValue": {
"limit": 8,
"unit": "Terabytes"
},
"scaleSize": {
"limit": 32,
"unit": "Gigabytes"
},
"status": "Available"
}
],
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
},
{
"name": "SQL_EastUS_MI_1",
"status": "Available"
},
{
"name": "SQL_EastUS_MI_2",
"status": "Available"
}
],
"status": "Available"
}
],
"status": "Available"
},
{
"name": "Gen5",
"sku": "GP_Gen5",
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"supportedVcoresValues": [
{
"name": "8",
"value": 8,
"includedMaxSize": {
"limit": 262144,
"unit": "Megabytes"
},
"supportedStorageSizes": [
{
"minValue": {
"limit": 32,
"unit": "Gigabytes"
},
"maxValue": {
"limit": 8,
"unit": "Terabytes"
},
"scaleSize": {
"limit": 32,
"unit": "Gigabytes"
},
"status": "Available"
}
],
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
},
{
"name": "SQL_EastUS_MI_1",
"status": "Available"
},
{
"name": "SQL_EastUS_MI_2",
"status": "Available"
}
],
"status": "Default"
},
{
"name": "16",
"value": 16,
"includedMaxSize": {
"limit": 262144,
"unit": "Megabytes"
},
"supportedStorageSizes": [
{
"minValue": {
"limit": 32,
"unit": "Gigabytes"
},
"maxValue": {
"limit": 8,
"unit": "Terabytes"
},
"scaleSize": {
"limit": 32,
"unit": "Gigabytes"
},
"status": "Available"
}
],
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
},
{
"name": "SQL_EastUS_MI_1",
"status": "Available"
},
{
"name": "SQL_EastUS_MI_2",
"status": "Available"
}
],
"status": "Available"
},
{
"name": "24",
"value": 24,
"includedMaxSize": {
"limit": 262144,
"unit": "Megabytes"
},
"supportedStorageSizes": [
{
"minValue": {
"limit": 32,
"unit": "Gigabytes"
},
"maxValue": {
"limit": 8,
"unit": "Terabytes"
},
"scaleSize": {
"limit": 32,
"unit": "Gigabytes"
},
"status": "Available"
}
],
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
},
{
"name": "SQL_EastUS_MI_1",
"status": "Available"
},
{
"name": "SQL_EastUS_MI_2",
"status": "Available"
}
],
"status": "Available"
}
],
"status": "Default"
}
],
"supportedStorageCapabilities": [
{
"storageAccountType": "GRS",
"status": "Default"
},
{
"storageAccountType": "LRS",
"status": "Available"
},
{
"storageAccountType": "ZRS",
"status": "Visible",
"reason": "ZRS is available in multi-az regions"
},
{
"storageAccountType": "GZRS",
"status": "Available",
"reason": "GZRS is available in multi-az regions"
}
],
"status": "Default"
},
{
"name": "Hyperscale",
"supportedFamilies": [
{
"name": "Gen4",
"sku": "HS_Gen4",
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"supportedVcoresValues": [
{
"name": "4",
"value": 4,
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
}
],
"status": "Available"
},
{
"name": "8",
"value": 8,
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
}
],
"status": "Default"
},
{
"name": "16",
"value": 16,
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
}
],
"status": "Available"
},
{
"name": "24",
"value": 24,
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
}
],
"status": "Available"
}
],
"status": "Default"
},
{
"name": "Gen5",
"sku": "HS_Gen5",
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"supportedVcoresValues": [
{
"name": "4",
"value": 4,
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
}
],
"status": "Available"
},
{
"name": "8",
"value": 8,
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
}
],
"status": "Default"
},
{
"name": "16",
"value": 16,
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
}
],
"status": "Available"
},
{
"name": "24",
"value": 24,
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
}
],
"status": "Available"
},
{
"name": "32",
"value": 32,
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
}
],
"status": "Available"
},
{
"name": "40",
"value": 40,
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
}
],
"status": "Available"
},
{
"name": "48",
"value": 48,
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
}
],
"status": "Available"
},
{
"name": "64",
"value": 64,
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
}
],
"status": "Available"
},
{
"name": "80",
"value": 80,
"instancePoolSupported": true,
"standaloneSupported": true,
"supportedMaintenanceConfigurations": [
{
"name": "SQL_Default",
"status": "Default"
}
],
"status": "Available"
}
],
"status": "Available"
}
],
"supportedStorageCapabilities": [
{
"storageAccountType": "GRS",
"status": "Default"
},
{
"storageAccountType": "LRS",
"status": "Available"
},
{
"storageAccountType": "ZRS",
"status": "Available",
"reason": "ZRS is available in multi-az regions"
},
{
"storageAccountType": "GZRS",
"status": "Available",
"reason": "GZRS is available in multi-az regions"
}
],
"status": "Available"
}
],
"supportedInstancePoolEditions": [
{
"name": "GeneralPurpose",
"supportedFamilies": [
{
"name": "Gen5",
"supportedLicenseTypes": [
{
"name": "LicenseIncluded",
"status": "Default"
},
{
"name": "BasePrice",
"status": "Available"
}
],
"supportedVcoresValues": [
{
"name": "GP_Gen5_8",
"value": 8,
"storageLimit": {
"limit": 8388608,
"unit": "Megabytes"
},
"status": "Default"
},
{
"name": "GP_Gen5_16",
"value": 16,
"storageLimit": {
"limit": 8388608,
"unit": "Megabytes"
},
"status": "Available"
},
{
"name": "GP_Gen5_24",
"value": 24,
"storageLimit": {
"limit": 8388608,
"unit": "Megabytes"
},
"status": "Available"
},
{
"name": "GP_Gen5_32",
"value": 32,
"storageLimit": {
"limit": 8388608,
"unit": "Megabytes"
},
"status": "Available"
},
{
"name": "GP_Gen5_40",
"value": 40,
"storageLimit": {
"limit": 8388608,
"unit": "Megabytes"
},
"status": "Available"
},
{
"name": "GP_Gen5_64",
"value": 64,
"storageLimit": {
"limit": 8388608,
"unit": "Megabytes"
},
"status": "Available"
},
{
"name": "GP_Gen5_80",
"value": 80,
"storageLimit": {
"limit": 8388608,
"unit": "Megabytes"
},
"status": "Available"
}
],
"status": "Default"
}
],
"status": "Default"
}
],
"status": "Default"
}
],
"status": "Available"
}Definitions
| Name | Description |
|---|---|
|
Auto |
Supported auto pause delay time range |
|
Capability |
If specified, restricts the response to only include the selected item. |
|
Capability |
The status of the capability. |
|
Edition |
The edition capability. |
|
Elastic |
The elastic pool edition capability. |
|
Elastic |
The max per-database performance level capability. |
|
Elastic |
The minimum per-database performance level capability. |
|
Elastic |
The Elastic Pool performance level capability. |
|
Instance |
The instance pool capability |
|
Instance |
The instance pool family capability. |
|
Instance |
The managed instance virtual cores capability. |
|
License |
The license type capability |
|
Location |
The location capability. |
|
Log |
The log size capability. |
|
Log |
The units that the limit is expressed in. |
|
Maintenance |
The maintenance configuration capability |
|
Managed |
The managed server capability |
|
Managed |
The managed server family capability. |
|
Managed |
The maintenance configuration capability |
|
Managed |
The managed instance virtual cores capability. |
|
Managed |
The managed instance capability |
|
Max |
The maximum size capability. |
|
Max |
The maximum size range capability. |
|
Max |
The units that the limit is expressed in. |
|
Min |
The min capacity capability |
|
Pause |
Unit of time that delay is expressed in |
|
Performance |
The performance level capability. |
|
Performance |
Unit type used to measure performance level. |
|
Read |
The read scale capability. |
|
Server |
The server capability |
|
Service |
The service objectives capability. |
| Sku |
An ARM Resource SKU. |
|
Storage |
The storage account type capability. |
AutoPauseDelayTimeRange
Supported auto pause delay time range
| Name | Type | Description |
|---|---|---|
| default |
integer |
Default value is no value is provided |
| doNotPauseValue |
integer |
Value that is used to not pause (infinite delay before pause) |
| maxValue |
integer |
Maximum value |
| minValue |
integer |
Minimum value |
| stepSize |
integer |
Step value for discrete values between the minimum value and the maximum value. |
| unit |
Unit of time that delay is expressed in |
CapabilityGroup
If specified, restricts the response to only include the selected item.
| Name | Type | Description |
|---|---|---|
| supportedEditions |
string |
|
| supportedElasticPoolEditions |
string |
|
| supportedInstancePoolEditions |
string |
|
| supportedManagedInstanceEditions |
string |
|
| supportedManagedInstanceVersions |
string |
CapabilityStatus
The status of the capability.
| Name | Type | Description |
|---|---|---|
| Available |
string |
|
| Default |
string |
|
| Disabled |
string |
|
| Visible |
string |
EditionCapability
The edition capability.
| Name | Type | Description |
|---|---|---|
| name |
string |
The database edition name. |
| readScale |
The read scale capability for the edition. |
|
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
|
| supportedServiceLevelObjectives |
The list of supported service objectives for the edition. |
|
| supportedStorageCapabilities |
The list of supported storage capabilities for this edition |
|
| zoneRedundant |
boolean |
Whether or not zone redundancy is supported for the edition. |
ElasticPoolEditionCapability
The elastic pool edition capability.
| Name | Type | Description |
|---|---|---|
| name |
string |
The elastic pool edition name. |
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
|
| supportedElasticPoolPerformanceLevels |
The list of supported elastic pool DTU levels for the edition. |
|
| zoneRedundant |
boolean |
Whether or not zone redundancy is supported for the edition. |
ElasticPoolPerDatabaseMaxPerformanceLevelCapability
The max per-database performance level capability.
| Name | Type | Description |
|---|---|---|
| limit |
number |
The maximum performance level per database. |
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
|
| supportedPerDatabaseMinPerformanceLevels |
The list of supported min database performance levels. |
|
| unit |
Unit type used to measure performance level. |
ElasticPoolPerDatabaseMinPerformanceLevelCapability
The minimum per-database performance level capability.
| Name | Type | Description |
|---|---|---|
| limit |
number |
The minimum performance level per database. |
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
|
| unit |
Unit type used to measure performance level. |
ElasticPoolPerformanceLevelCapability
The Elastic Pool performance level capability.
| Name | Type | Description |
|---|---|---|
| includedMaxSize |
The included (free) max size for this performance level. |
|
| maxDatabaseCount |
integer |
The maximum number of databases supported. |
| performanceLevel |
The performance level for the pool. |
|
| reason |
string |
The reason for the capability not being available. |
| sku |
The sku. |
|
| status |
The status of the capability. |
|
| supportedLicenseTypes |
List of supported license types. |
|
| supportedMaintenanceConfigurations |
List of supported maintenance configurations |
|
| supportedMaxSizes |
The list of supported max sizes. |
|
| supportedPerDatabaseMaxPerformanceLevels |
The list of supported per database max performance levels. |
|
| supportedPerDatabaseMaxSizes |
The list of supported per database max sizes. |
|
| zoneRedundant |
boolean |
Whether or not zone redundancy is supported for the performance level. |
InstancePoolEditionCapability
The instance pool capability
| Name | Type | Description |
|---|---|---|
| name |
string |
The instance pool version name. |
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
|
| supportedFamilies |
The supported families. |
InstancePoolFamilyCapability
The instance pool family capability.
| Name | Type | Description |
|---|---|---|
| name |
string |
Family name. |
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
|
| supportedLicenseTypes |
List of supported license types. |
|
| supportedVcoresValues |
List of supported virtual cores values. |
InstancePoolVcoresCapability
The managed instance virtual cores capability.
| Name | Type | Description |
|---|---|---|
| name |
string |
The virtual cores identifier. |
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
|
| storageLimit |
Storage limit. |
|
| value |
integer |
The virtual cores value. |
LicenseTypeCapability
The license type capability
| Name | Type | Description |
|---|---|---|
| name |
string |
License type identifier. |
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
LocationCapabilities
The location capability.
| Name | Type | Description |
|---|---|---|
| name |
string |
The location name. |
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
|
| supportedManagedInstanceVersions |
The list of supported managed instance versions. |
|
| supportedServerVersions |
The list of supported server versions. |
LogSizeCapability
The log size capability.
| Name | Type | Description |
|---|---|---|
| limit |
integer |
The log size limit (see 'unit' for the units). |
| unit |
The units that the limit is expressed in. |
LogSizeUnit
The units that the limit is expressed in.
| Name | Type | Description |
|---|---|---|
| Gigabytes |
string |
|
| Megabytes |
string |
|
| Percent |
string |
|
| Petabytes |
string |
|
| Terabytes |
string |
MaintenanceConfigurationCapability
The maintenance configuration capability
| Name | Type | Description |
|---|---|---|
| name |
string |
Maintenance configuration name |
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
|
| zoneRedundant |
boolean |
Whether or not zone redundancy is supported for the maintenance configuration. |
ManagedInstanceEditionCapability
The managed server capability
| Name | Type | Description |
|---|---|---|
| name |
string |
The managed server version name. |
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
|
| supportedFamilies |
The supported families. |
|
| supportedStorageCapabilities |
The list of supported storage capabilities for this edition |
|
| zoneRedundant |
boolean |
Whether or not zone redundancy is supported for the edition. |
ManagedInstanceFamilyCapability
The managed server family capability.
| Name | Type | Description |
|---|---|---|
| name |
string |
Family name. |
| reason |
string |
The reason for the capability not being available. |
| sku |
string |
SKU name. |
| status |
The status of the capability. |
|
| supportedLicenseTypes |
List of supported license types. |
|
| supportedVcoresValues |
List of supported virtual cores values. |
ManagedInstanceMaintenanceConfigurationCapability
The maintenance configuration capability
| Name | Type | Description |
|---|---|---|
| name |
string |
Maintenance configuration name |
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
ManagedInstanceVcoresCapability
The managed instance virtual cores capability.
| Name | Type | Description |
|---|---|---|
| includedMaxSize |
Included size. |
|
| instancePoolSupported |
boolean |
True if this service objective is supported for managed instances in an instance pool. |
| name |
string |
The virtual cores identifier. |
| reason |
string |
The reason for the capability not being available. |
| standaloneSupported |
boolean |
True if this service objective is supported for standalone managed instances. |
| status |
The status of the capability. |
|
| supportedMaintenanceConfigurations |
List of supported maintenance configurations |
|
| supportedStorageSizes |
Storage size ranges. |
|
| value |
integer |
The virtual cores value. |
ManagedInstanceVersionCapability
The managed instance capability
| Name | Type | Description |
|---|---|---|
| name |
string |
The server version name. |
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
|
| supportedEditions |
The list of supported managed instance editions. |
|
| supportedInstancePoolEditions |
The list of supported instance pool editions. |
MaxSizeCapability
The maximum size capability.
| Name | Type | Description |
|---|---|---|
| limit |
integer |
The maximum size limit (see 'unit' for the units). |
| unit |
The units that the limit is expressed in. |
MaxSizeRangeCapability
The maximum size range capability.
| Name | Type | Description |
|---|---|---|
| logSize |
Size of transaction log. |
|
| maxValue |
Maximum value. |
|
| minValue |
Minimum value. |
|
| reason |
string |
The reason for the capability not being available. |
| scaleSize |
Scale/step size for discrete values between the minimum value and the maximum value. |
|
| status |
The status of the capability. |
MaxSizeUnit
The units that the limit is expressed in.
| Name | Type | Description |
|---|---|---|
| Gigabytes |
string |
|
| Megabytes |
string |
|
| Petabytes |
string |
|
| Terabytes |
string |
MinCapacityCapability
The min capacity capability
| Name | Type | Description |
|---|---|---|
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
|
| value |
number |
Min capacity value |
PauseDelayTimeUnit
Unit of time that delay is expressed in
| Name | Type | Description |
|---|---|---|
| Minutes |
string |
PerformanceLevelCapability
The performance level capability.
| Name | Type | Description |
|---|---|---|
| unit |
Unit type used to measure performance level. |
|
| value |
number |
Performance level value. |
PerformanceLevelUnit
Unit type used to measure performance level.
| Name | Type | Description |
|---|---|---|
| DTU |
string |
|
| VCores |
string |
ReadScaleCapability
The read scale capability.
| Name | Type | Description |
|---|---|---|
| maxNumberOfReplicas |
integer |
The maximum number of read scale replicas. |
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
ServerVersionCapability
The server capability
| Name | Type | Description |
|---|---|---|
| name |
string |
The server version name. |
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
|
| supportedEditions |
The list of supported database editions. |
|
| supportedElasticPoolEditions |
The list of supported elastic pool editions. |
ServiceObjectiveCapability
The service objectives capability.
| Name | Type | Description |
|---|---|---|
| computeModel |
string |
The compute model |
| id |
string |
The unique ID of the service objective. |
| includedMaxSize |
The included (free) max size. |
|
| name |
string |
The service objective name. |
| performanceLevel |
The performance level. |
|
| reason |
string |
The reason for the capability not being available. |
| sku |
The sku. |
|
| status |
The status of the capability. |
|
| supportedAutoPauseDelay |
Supported time range for auto pause delay |
|
| supportedLicenseTypes |
List of supported license types. |
|
| supportedMaintenanceConfigurations |
List of supported maintenance configurations |
|
| supportedMaxSizes |
The list of supported maximum database sizes. |
|
| supportedMinCapacities |
List of supported min capacities |
|
| zoneRedundant |
boolean |
Whether or not zone redundancy is supported for the service objective. |
Sku
An ARM Resource SKU.
| Name | Type | Description |
|---|---|---|
| capacity |
integer |
Capacity of the particular SKU. |
| family |
string |
If the service has different generations of hardware, for the same SKU, then that can be captured here. |
| name |
string |
The name of the SKU, typically, a letter + Number code, e.g. P3. |
| size |
string |
Size of the particular SKU |
| tier |
string |
The tier or edition of the particular SKU, e.g. Basic, Premium. |
StorageCapability
The storage account type capability.
| Name | Type | Description |
|---|---|---|
| reason |
string |
The reason for the capability not being available. |
| status |
The status of the capability. |
|
| storageAccountType |
enum:
|
The storage account type for the database's backups. |