你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站,请访问 https://docs.azure.cn。
Elastic Pools - Create Or Update
创建或更新弹性池。
PUT https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/elasticPools/{elasticPoolName}?api-version=2023-08-01
URI 参数
名称 | 在 | 必需 | 类型 | 说明 |
---|---|---|---|---|
elastic
|
path | True |
string |
弹性池的名称。 |
resource
|
path | True |
string |
包含资源的资源组的名称。 可以从 Azure 资源管理器 API 或门户获取此值。 |
server
|
path | True |
string |
服务器的名称。 |
subscription
|
path | True |
string |
标识 Azure 订阅的订阅 ID。 |
api-version
|
query | True |
string |
要用于请求的 API 版本。 |
请求正文
名称 | 必需 | 类型 | 说明 |
---|---|---|---|
location | True |
string |
资源位置。 |
properties.autoPauseDelay |
integer (int32) |
弹性池自动暂停的时间(以分钟为单位)。 -1 值表示禁用自动暂停 |
|
properties.availabilityZone |
指定池的主要副本固定到的可用性区域。 |
||
properties.highAvailabilityReplicaCount |
integer (int32) |
与用于提供高可用性的业务关键版、高级版或超大规模版弹性池关联的次要副本数。 仅适用于“超大规模”弹性池。 |
|
properties.licenseType |
要申请此弹性池的许可证类型。 |
||
properties.maintenanceConfigurationId |
string |
分配给弹性池的维护配置 ID。 此配置定义将发生维护更新的时间段。 |
|
properties.maxSizeBytes |
integer (int64) |
数据库弹性池的存储限制(以字节为单位)。 |
|
properties.minCapacity |
number (double) |
无服务器池不会缩小到的最小容量(如果未暂停) |
|
properties.perDatabaseSettings |
弹性池的每个数据库设置。 |
||
properties.preferredEnclaveType |
弹性池上请求的 enclave 类型。 |
||
properties.zoneRedundant |
boolean |
此弹性池是否为区域冗余,这意味着此弹性池的副本将分布在多个可用性区域。 |
|
sku |
弹性池 SKU。 SKU 列表可能因区域和支持产品/服务而异。 若要确定可用于 Azure 区域中订阅的 SKU(包括 SKU 名称、层/版本、系列和容量),请使用
|
||
tags |
object |
资源标记。 |
响应
名称 | 类型 | 说明 |
---|---|---|
200 OK |
更新了弹性池 |
|
201 Created |
创建了弹性池 |
|
202 Accepted |
接受 标头 Location: string |
|
Other Status Codes |
错误响应: ***
|
示例
Create or Update an elastic pool with Availability Zone
示例请求
PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102?api-version=2023-08-01
{
"location": "Japan East",
"sku": {
"name": "HS_Gen5_4"
},
"properties": {
"perDatabaseSettings": {
"minCapacity": 0.25,
"maxCapacity": 2
},
"zoneRedundant": true,
"availabilityZone": "1"
}
}
示例响应
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
"name": "sqlcrudtest-8102",
"type": "Microsoft.Sql/servers/elasticPools",
"location": "Japan East",
"kind": null,
"sku": {
"name": "StandardPool",
"tier": "Standard",
"capacity": 100
},
"properties": {
"creationDate": "2017-02-10T01:25:25.033Z",
"state": "Ready",
"maxSizeBytes": 102400,
"perDatabaseSettings": {
"minCapacity": 0.25,
"maxCapacity": 2
},
"zoneRedundant": true,
"availabilityZone": "1"
}
}
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/locations/japaneast1/operationStatus/default/operationId/00000000-0000-0000-0000-000000000000?api-version=2022-08-01
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
"name": "sqlcrudtest-8102",
"type": "Microsoft.Sql/servers/elasticPools",
"location": "Japan East",
"kind": null,
"sku": {
"name": "StandardPool",
"tier": "Standard",
"capacity": 100
},
"properties": {
"creationDate": "2017-02-10T01:25:25.033Z",
"state": "Ready",
"maxSizeBytes": 102400,
"perDatabaseSettings": {
"minCapacity": 0.25,
"maxCapacity": 2
},
"availabilityZone": "1"
}
}
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/locations/japaneast1/operationStatus/default/operationId/00000000-0000-0000-0000-000000000000?api-version=2022-08-01
Create or Update an elastic pool with serverless properties
示例请求
PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102?api-version=2023-08-01
{
"location": "Japan East",
"sku": {
"name": "GP_S_Gen5_2",
"tier": "GeneralPurpose",
"capacity": 2
},
"properties": {
"minCapacity": 0.5,
"autoPauseDelay": 60,
"perDatabaseSettings": {
"minCapacity": 0,
"maxCapacity": 2,
"autoPauseDelay": 80
}
}
}
示例响应
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
"name": "sqlcrudtest-8102",
"type": "Microsoft.Sql/servers/elasticPools",
"location": "Japan East",
"kind": null,
"sku": {
"name": "GP_S_Gen5_2",
"tier": "GeneralPurpose",
"capacity": 2
},
"properties": {
"creationDate": "2017-02-10T01:25:25.033Z",
"state": "Ready",
"maxSizeBytes": 102400,
"minCapacity": 0.5,
"autoPauseDelay": 60,
"perDatabaseSettings": {
"minCapacity": 0,
"maxCapacity": 2,
"autoPauseDelay": 80
}
}
}
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/locations/japaneast1/operationStatus/default/operationId/00000000-0000-0000-0000-000000000000?api-version=2023-05-01
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
"name": "sqlcrudtest-8102",
"type": "Microsoft.Sql/servers/elasticPools",
"location": "Japan East",
"kind": null,
"sku": {
"name": "GP_S_Gen5_2",
"tier": "GeneralPurpose",
"capacity": 2
},
"properties": {
"creationDate": "2017-02-10T01:25:25.033Z",
"state": "Ready",
"maxSizeBytes": 102400,
"minCapacity": 0.5,
"autoPauseDelay": 60,
"perDatabaseSettings": {
"minCapacity": 0,
"maxCapacity": 2,
"autoPauseDelay": 80
}
}
}
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/locations/japaneast1/operationStatus/default/operationId/00000000-0000-0000-0000-000000000000?api-version=2023-05-01
Create or update elastic pool with all parameter
示例请求
PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102?api-version=2023-08-01
{
"location": "Japan East",
"sku": {
"name": "GP_Gen4_2",
"tier": "GeneralPurpose",
"capacity": 2
},
"properties": {
"perDatabaseSettings": {
"minCapacity": 0.25,
"maxCapacity": 2
}
}
}
示例响应
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
"name": "sqlcrudtest-8102",
"type": "Microsoft.Sql/servers/elasticPools",
"location": "Japan East",
"kind": null,
"sku": {
"name": "GP_Gen4_2",
"tier": "GeneralPurpose",
"capacity": 2
},
"properties": {
"creationDate": "2017-02-10T01:25:25.033Z",
"state": "Ready",
"maxSizeBytes": 5242880000,
"perDatabaseSettings": {
"minCapacity": 0.25,
"maxCapacity": 2
}
}
}
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/locations/japaneast1/operationStatus/default/operationId/00000000-0000-0000-0000-000000000000?api-version=2017-10-01
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
"name": "sqlcrudtest-8102",
"type": "Microsoft.Sql/servers/elasticPools",
"location": "Japan East",
"kind": null,
"sku": {
"name": "GP_Gen4_2",
"tier": "GeneralPurpose",
"capacity": 2
},
"properties": {
"creationDate": "2017-02-10T01:25:25.033Z",
"state": "Ready",
"maxSizeBytes": 5242880000,
"perDatabaseSettings": {
"minCapacity": 0.25,
"maxCapacity": 2
}
}
}
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/locations/japaneast1/operationStatus/default/operationId/00000000-0000-0000-0000-000000000000?api-version=2017-10-01
Create or update elastic pool with maintenance configuration parameter
示例请求
PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102?api-version=2023-08-01
{
"location": "Japan East",
"properties": {
"maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_1"
}
}
示例响应
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
"name": "sqlcrudtest-8102",
"type": "Microsoft.Sql/servers/elasticPools",
"location": "Japan East",
"kind": null,
"sku": {
"name": "StandardPool",
"tier": "Standard",
"capacity": 100
},
"properties": {
"creationDate": "2017-02-10T01:25:25.033Z",
"state": "Ready",
"maxSizeBytes": 102400,
"perDatabaseSettings": {
"minCapacity": 0,
"maxCapacity": 100
},
"maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_1"
}
}
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/locations/japaneast1/operationStatus/default/operationId/00000000-0000-0000-0000-000000000000?api-version=2020-08-01
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
"name": "sqlcrudtest-8102",
"type": "Microsoft.Sql/servers/elasticPools",
"location": "Japan East",
"kind": null,
"sku": {
"name": "StandardPool",
"tier": "Standard",
"capacity": 100
},
"properties": {
"creationDate": "2017-02-10T01:25:25.033Z",
"state": "Ready",
"maxSizeBytes": 102400,
"perDatabaseSettings": {
"minCapacity": 0,
"maxCapacity": 100
},
"maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_1"
}
}
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/locations/japaneast1/operationStatus/default/operationId/00000000-0000-0000-0000-000000000000?api-version=2020-08-01
Create or update elastic pool with minimum parameters
示例请求
PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102?api-version=2023-08-01
{
"location": "Japan East"
}
示例响应
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
"name": "sqlcrudtest-8102",
"type": "Microsoft.Sql/servers/elasticPools",
"location": "Japan East",
"kind": null,
"sku": {
"name": "StandardPool",
"tier": "Standard",
"capacity": 100
},
"properties": {
"creationDate": "2017-02-10T01:25:25.033Z",
"state": "Ready",
"maxSizeBytes": 102400,
"perDatabaseSettings": {
"minCapacity": 0,
"maxCapacity": 100
}
}
}
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/locations/japaneast1/operationStatus/default/operationId/00000000-0000-0000-0000-000000000000?api-version=2017-10-01
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
"name": "sqlcrudtest-8102",
"type": "Microsoft.Sql/servers/elasticPools",
"location": "Japan East",
"kind": null,
"sku": {
"name": "StandardPool",
"tier": "Standard",
"capacity": 100
},
"properties": {
"creationDate": "2017-02-10T01:25:25.033Z",
"state": "Ready",
"maxSizeBytes": 102400,
"perDatabaseSettings": {
"minCapacity": 0,
"maxCapacity": 100
}
}
}
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/locations/japaneast1/operationStatus/default/operationId/00000000-0000-0000-0000-000000000000?api-version=2017-10-01
Create or update elastic pool with preferred enclave type parameter as Default
示例请求
PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102?api-version=2023-08-01
{
"location": "Japan East",
"sku": {
"name": "GP_Gen5_4"
},
"properties": {
"preferredEnclaveType": "Default"
}
}
示例响应
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
"name": "sqlcrudtest-8102",
"type": "Microsoft.Sql/servers/elasticPools",
"location": "Japan East",
"kind": "vcore,pool",
"sku": {
"name": "GP_Gen5",
"tier": "GeneralPurpose",
"family": "Gen5",
"capacity": 4
},
"properties": {
"state": "Ready",
"creationDate": "2022-08-26T03:46:20.57Z",
"maxSizeBytes": 0,
"perDatabaseSettings": {
"minCapacity": 0,
"maxCapacity": 4
},
"zoneRedundant": false,
"licenseType": "LicenseIncluded",
"maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default",
"preferredEnclaveType": "Default"
}
}
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/locations/japaneast1/operationStatus/default/operationId/00000000-0000-0000-0000-000000000000?api-version=2022-08-01
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
"name": "sqlcrudtest-8102",
"type": "Microsoft.Sql/servers/elasticPools",
"location": "Japan East",
"kind": "vcore,pool",
"sku": {
"name": "GP_Gen5",
"tier": "GeneralPurpose",
"family": "Gen5",
"capacity": 4
},
"properties": {
"state": "Ready",
"creationDate": "2022-08-26T03:46:20.57Z",
"maxSizeBytes": 0,
"perDatabaseSettings": {
"minCapacity": 0,
"maxCapacity": 4
},
"zoneRedundant": false,
"licenseType": "LicenseIncluded",
"maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default",
"preferredEnclaveType": "Default"
}
}
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/locations/japaneast1/operationStatus/default/operationId/00000000-0000-0000-0000-000000000000?api-version=2022-08-01
Create or update elastic pool with preferred enclave type parameter as VBS
示例请求
PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102?api-version=2023-08-01
{
"location": "Japan East",
"sku": {
"name": "GP_Gen5_4"
},
"properties": {
"preferredEnclaveType": "VBS"
}
}
示例响应
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
"name": "sqlcrudtest-8102",
"type": "Microsoft.Sql/servers/elasticPools",
"location": "Japan East",
"kind": "vcore,pool",
"sku": {
"name": "GP_Gen5",
"tier": "GeneralPurpose",
"family": "Gen5",
"capacity": 4
},
"properties": {
"state": "Ready",
"creationDate": "2022-08-26T03:46:20.57Z",
"maxSizeBytes": 0,
"perDatabaseSettings": {
"minCapacity": 0,
"maxCapacity": 4
},
"zoneRedundant": false,
"licenseType": "LicenseIncluded",
"maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default",
"preferredEnclaveType": "VBS"
}
}
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/locations/japaneast1/operationStatus/default/operationId/00000000-0000-0000-0000-000000000000?api-version=2022-08-01
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
"name": "sqlcrudtest-8102",
"type": "Microsoft.Sql/servers/elasticPools",
"location": "Japan East",
"kind": "vcore,pool",
"sku": {
"name": "GP_Gen5",
"tier": "GeneralPurpose",
"family": "Gen5",
"capacity": 4
},
"properties": {
"state": "Ready",
"creationDate": "2022-08-26T03:46:20.57Z",
"maxSizeBytes": 0,
"perDatabaseSettings": {
"minCapacity": 0,
"maxCapacity": 4
},
"zoneRedundant": false,
"licenseType": "LicenseIncluded",
"maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default",
"preferredEnclaveType": "VBS"
}
}
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/locations/japaneast1/operationStatus/default/operationId/00000000-0000-0000-0000-000000000000?api-version=2022-08-01
Create or update Hyperscale elastic pool with high availability replica count parameter
示例请求
PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102?api-version=2023-08-01
{
"location": "Japan East",
"sku": {
"name": "HS_Gen5_4"
},
"properties": {
"highAvailabilityReplicaCount": 2
}
}
示例响应
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
"name": "sqlcrudtest-8102",
"type": "Microsoft.Sql/servers/elasticPools",
"location": "Japan East",
"kind": "vcore,pool",
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 4
},
"properties": {
"state": "Ready",
"creationDate": "2021-08-26T03:46:20.57Z",
"maxSizeBytes": 0,
"perDatabaseSettings": {
"minCapacity": 0,
"maxCapacity": 4
},
"zoneRedundant": false,
"licenseType": "LicenseIncluded",
"maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default",
"highAvailabilityReplicaCount": 2
}
}
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/locations/japaneast1/operationStatus/default/operationId/00000000-0000-0000-0000-000000000000?api-version=2021-08-01
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
"name": "sqlcrudtest-8102",
"type": "Microsoft.Sql/servers/elasticPools",
"location": "Japan East",
"kind": "vcore,pool",
"sku": {
"name": "HS_Gen5",
"tier": "Hyperscale",
"family": "Gen5",
"capacity": 4
},
"properties": {
"state": "Ready",
"creationDate": "2021-08-26T03:46:20.57Z",
"maxSizeBytes": 0,
"perDatabaseSettings": {
"minCapacity": 0,
"maxCapacity": 4
},
"zoneRedundant": false,
"licenseType": "LicenseIncluded",
"maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default",
"highAvailabilityReplicaCount": 2
}
}
Location: https://management.azure.com/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/locations/japaneast1/operationStatus/default/operationId/00000000-0000-0000-0000-000000000000?api-version=2021-08-01
定义
名称 | 说明 |
---|---|
Always |
弹性池上请求的 enclave 类型。 |
Availability |
指定池的主要副本固定到的可用性区域。 |
Elastic |
弹性池。 |
Elastic |
要申请此弹性池的许可证类型。 |
Elastic |
弹性池的数据库设置。 |
Elastic |
弹性池的状态。 |
Error |
资源管理错误附加信息。 |
Error |
错误详细信息。 |
Error |
错误响应 |
Sku |
ARM 资源 SKU。 |
AlwaysEncryptedEnclaveType
弹性池上请求的 enclave 类型。
值 | 说明 |
---|---|
Default | |
VBS |
AvailabilityZoneType
指定池的主要副本固定到的可用性区域。
值 | 说明 |
---|---|
1 | |
2 | |
3 | |
NoPreference |
ElasticPool
弹性池。
名称 | 类型 | 说明 |
---|---|---|
id |
string |
资源 ID。 |
kind |
string |
弹性池的类型。 这是用于 Azure 门户体验的元数据。 |
location |
string |
资源位置。 |
name |
string |
资源名称。 |
properties.autoPauseDelay |
integer (int32) |
弹性池自动暂停的时间(以分钟为单位)。 -1 值表示禁用自动暂停 |
properties.availabilityZone |
指定池的主要副本固定到的可用性区域。 |
|
properties.creationDate |
string (date-time) |
弹性池的创建日期(ISO8601格式)。 |
properties.highAvailabilityReplicaCount |
integer (int32) |
与用于提供高可用性的业务关键版、高级版或超大规模版弹性池关联的次要副本数。 仅适用于“超大规模”弹性池。 |
properties.licenseType |
要申请此弹性池的许可证类型。 |
|
properties.maintenanceConfigurationId |
string |
分配给弹性池的维护配置 ID。 此配置定义将发生维护更新的时间段。 |
properties.maxSizeBytes |
integer (int64) |
数据库弹性池的存储限制(以字节为单位)。 |
properties.minCapacity |
number (double) |
无服务器池不会缩小到的最小容量(如果未暂停) |
properties.perDatabaseSettings |
弹性池的每个数据库设置。 |
|
properties.preferredEnclaveType |
弹性池上请求的 enclave 类型。 |
|
properties.state |
弹性池的状态。 |
|
properties.zoneRedundant |
boolean |
此弹性池是否为区域冗余,这意味着此弹性池的副本将分布在多个可用性区域。 |
sku |
弹性池 SKU。 SKU 列表可能因区域和支持产品/服务而异。 若要确定可用于 Azure 区域中订阅的 SKU(包括 SKU 名称、层/版本、系列和容量),请使用
|
|
tags |
object |
资源标记。 |
type |
string |
资源类型。 |
ElasticPoolLicenseType
要申请此弹性池的许可证类型。
值 | 说明 |
---|---|
BasePrice | |
LicenseIncluded |
ElasticPoolPerDatabaseSettings
弹性池的数据库设置。
名称 | 类型 | 说明 |
---|---|---|
autoPauseDelay |
integer (int32) |
池中每个数据库的自动暂停延迟 |
maxCapacity |
number (double) |
任何一个数据库都可以使用的最大容量。 |
minCapacity |
number (double) |
保证所有数据库的最小容量。 |
ElasticPoolState
弹性池的状态。
值 | 说明 |
---|---|
Creating | |
Disabled | |
Ready |
ErrorAdditionalInfo
资源管理错误附加信息。
名称 | 类型 | 说明 |
---|---|---|
info |
object |
其他信息。 |
type |
string |
其他信息类型。 |
ErrorDetail
错误详细信息。
名称 | 类型 | 说明 |
---|---|---|
additionalInfo |
错误附加信息。 |
|
code |
string |
错误代码。 |
details |
错误详细信息。 |
|
message |
string |
错误消息。 |
target |
string |
错误目标。 |
ErrorResponse
错误响应
名称 | 类型 | 说明 |
---|---|---|
error |
错误对象。 |
Sku
ARM 资源 SKU。
名称 | 类型 | 说明 |
---|---|---|
capacity |
integer (int32) |
特定 SKU 的容量。 |
family |
string |
如果服务具有不同代的硬件(对于同一 SKU,则可以在此处捕获)。 |
name |
string |
SKU 的名称,通常为字母 + 数字代码,例如 P3。 |
size |
string |
特定 SKU 的大小 |
tier |
string |
特定 SKU 的层或版本,例如基本 SKU、高级版。 |