你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站,请访问 https://docs.azure.cn。
Get-AzSqlInstancePoolUsage
返回有关 Azure SQL 实例池使用情况的信息。
语法
Get-AzSqlInstancePoolUsage
[-ResourceGroupName] <String>
[-Name] <String>
[-ExpandChildren]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Get-AzSqlInstancePoolUsage
[-InstancePool] <AzureSqlInstancePoolModel>
[-ExpandChildren]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Get-AzSqlInstancePoolUsage
[-ResourceId] <String>
[-ExpandChildren]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
说明
Get-AzSqlInstancePoolUsage cmdlet 返回 Azure SQL 实例池使用情况的信息。
示例
示例 1:获取 Azure SQL 实例池的使用情况
Get-AzSqlInstancePoolUsage -ResourceGroupName resourcegroup01 -Name instancepool0
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancepool0/usages/vcore_utilization
CurrentValue : 2
Limit : 8
RequestedLimit :
Unit : VCores
Name : VCore utilization
Type : Microsoft.Sql/instancePools/usages
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancepool0/usages/storage_utilization
CurrentValue : 32
Limit : 8192
RequestedLimit :
Unit : Gigabytes
Name : Storage utilization
Type : Microsoft.Sql/instancePools/usages
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancepool0/usages/database_utilization
CurrentValue : 0
Limit : 100
RequestedLimit :
Unit : Number Of Databases
Name : Database utilization
Type : Microsoft.Sql/instancePools/usages
获取 Azure SQL 实例池实例pool0 的用法。
示例 2:使用实例池对象获取 Azure SQL 实例池的用法
$instancePool = Get-AzSqlInstancePool -ResourceGroupName resourcegroup01 -Name instancepool0
Get-AzSqlInstancePoolUsage -InstancePool $instancePool
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancepool0/usages/vcore_utilization
CurrentValue : 2
Limit : 8
RequestedLimit :
Unit : VCores
Name : VCore utilization
Type : Microsoft.Sql/instancePools/usages
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancepool0/usages/storage_utilization
CurrentValue : 32
Limit : 8192
RequestedLimit :
Unit : Gigabytes
Name : Storage utilization
Type : Microsoft.Sql/instancePools/usages
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancepool0/usages/database_utilization
CurrentValue : 0
Limit : 100
RequestedLimit :
Unit : Number Of Databases
Name : Database utilization
Type : Microsoft.Sql/instancePools/usages
使用实例池对象获取 Azure SQL 实例池实例池的用法。
示例 3:使用实例池资源 ID 获取 Azure SQL 实例池的使用情况
Get-AzSqlInstancePoolUsage -ResourceId "/subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancePool0"
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancepool0/usages/vcore_utilization
CurrentValue : 2
Limit : 8
RequestedLimit :
Unit : VCores
Name : VCore utilization
Type : Microsoft.Sql/instancePools/usages
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancepool0/usages/storage_utilization
CurrentValue : 32
Limit : 8192
RequestedLimit :
Unit : Gigabytes
Name : Storage utilization
Type : Microsoft.Sql/instancePools/usages
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancepool0/usages/database_utilization
CurrentValue : 0
Limit : 100
RequestedLimit :
Unit : Number Of Databases
Name : Database utilization
Type : Microsoft.Sql/instancePools/usages
使用实例池资源标识符获取 Azure SQL 实例池实例池的用法。
示例 3:获取 Azure SQL 实例池的使用情况,其中细分了池中的托管实例使用情况。
Get-AzSqlInstancePoolUsage -ResourceGroupName resourcegroup01 -Name instancepool0 -ExpandChildren
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancepool0/usages/vcore_utilization
CurrentValue : 2
Limit : 8
RequestedLimit :
Unit : VCores
Name : VCore utilization
Type : Microsoft.Sql/instancePools/usages
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancepool0/usages/storage_utilization
CurrentValue : 32
Limit : 8192
RequestedLimit :
Unit : Gigabytes
Name : Storage utilization
Type : Microsoft.Sql/instancePools/usages
Id : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancepool0/usages/database_utilization
CurrentValue : 0
Limit : 100
RequestedLimit :
Unit : Number Of Databases
Name : Database utilization
Type : Microsoft.Sql/instancePools/usages
Id : /subscriptions/2e7fe4bd-90c7-454e-8bb6-dc44649f27b2/resourceGroups/poolsPS/providers/Microsoft.Sql/instancePools/instancepool0/managedInstances/managedinstance0/usages/vcore_utilization
CurrentValue :
Limit : 2
RequestedLimit :
Unit : VCores
Name : VCore utilization
Type : Microsoft.Sql/instancePools/managedInstances/usages
Id : /subscriptions/2e7fe4bd-90c7-454e-8bb6-dc44649f27b2/resourceGroups/poolsPS/providers/Microsoft.Sql/instancePools/instancepool0/managedInstances/managedinstance0/usages/storage_utilization
CurrentValue :
Limit : 32
RequestedLimit :
Unit : Gigabytes
Name : Storage utilization
Type : Microsoft.Sql/instancePools/managedInstances/usages
Id : /subscriptions/2e7fe4bd-90c7-454e-8bb6-dc44649f27b2/resourceGroups/poolsPS/providers/Microsoft.Sql/instancePools/instancepool0/managedInstances/managedinstance0/usages/database_utilization
CurrentValue : 0
Limit : 100
RequestedLimit :
Unit : Number Of Databases
Name : Database utilization
Type : Microsoft.Sql/instancePools/managedInstances/usages
获取 Azure SQL 实例池实例池实例池的用法以及 instancepool0 中的托管实例的用法。
参数
-DefaultProfile
用于与 Azure 通信的凭据、帐户、租户和订阅。
类型: | IAzureContextContainer |
别名: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
默认值: | None |
必需: | False |
接受管道输入: | False |
接受通配符: | False |
-ExpandChildren
指示是否扩展此实例池的使用情况及其子级的使用情况的标志。
类型: | SwitchParameter |
Position: | Named |
默认值: | None |
必需: | False |
接受管道输入: | False |
接受通配符: | False |
-InstancePool
父实例池对象。
类型: | AzureSqlInstancePoolModel |
Position: | 0 |
默认值: | None |
必需: | True |
接受管道输入: | True |
接受通配符: | False |
-Name
托管实例池名称。
类型: | String |
别名: | InstancePoolName |
Position: | 1 |
默认值: | None |
必需: | True |
接受管道输入: | False |
接受通配符: | False |
-ResourceGroupName
资源组名称。
类型: | String |
Position: | 0 |
默认值: | None |
必需: | True |
接受管道输入: | False |
接受通配符: | False |
-ResourceId
父资源 ID。
类型: | String |
别名: | InstancePoolResourceId |
Position: | 0 |
默认值: | None |
必需: | True |
接受管道输入: | True |
接受通配符: | False |