Get-AzSqlElasticPool
Ottiene i pool elastici e i relativi valori delle proprietà in un database SQL di Azure.
Get-AzSqlElasticPool
[[-ElasticPoolName] <String>]
[-ServerName] <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Il cmdlet Get-AzSqlElasticPool ottiene pool elastici e i relativi valori delle proprietà. Specificare il nome di un pool elastico esistente per visualizzare i valori delle proprietà solo per tale pool.
Get-AzSqlElasticPool -ResourceGroupName "ResourceGroup01" -ServerName "Server01"
ResourceId : /subscriptions/00000000-0000-0000-0000-000000000001/resourceGroups/resourcegroup01/providers/Microsoft.Sql/servers/server01/elasticPools/elasticpool01
ResourceGroupName : resourcegroup01
ServerName : server01
ElasticPoolName : elasticpool01
Location : Central US
CreationDate : 8/26/2015 10:00:17 PM
State : Ready
Edition : Standard
Dtu : 400
DatabaseDtuMax : 100
DatabaseDtuMin : 10
StorageMB : 409600
Tags :
ResourceId : /subscriptions/00000000-0000-0000-0000-000000000001/resourceGroups/resourcegroup01/providers/Microsoft.Sql/servers/server01/elasticPools/elasticpool02
ResourceGroupName : resourcegroup01
ServerName : server01
ElasticPoolName : elasticpool02
Location : Central US
CreationDate : 8/26/2015 11:00:17 PM
State : Ready
Edition : Standard
Dtu : 400
DatabaseDtuMax : 100
DatabaseDtuMin : 10
StorageMB : 409600
Tags :
Questo comando ottiene tutti i pool elastici nel server denominato Server01.
Get-AzSqlElasticPool -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ElasticPoolName "ElasticPool27"
ResourceId : /subscriptions/00000000-0000-0000-0000-000000000001/resourceGroups/resourcegroup01/providers/Microsoft.Sql/servers/server01/elasticPools/elasticpool01
ResourceGroupName : resourcegroup01
ServerName : server01
ElasticPoolName : elasticpool01
Location : Central US
CreationDate : 8/26/2015 10:00:17 PM
State : Ready
Edition : Standard
Dtu : 400
DatabaseDtuMax : 100
DatabaseDtuMin : 10
StorageMB : 409600
Tags :
Questo comando ottiene il pool elastico denominato ElasticPool0127 nel server denominato Server01.
Get-AzSqlElasticPool -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ElasticPoolName "ElasticPool01" | Get-AzMetric -TimeGrain 0:5:0 -MetricName storage_percent
DimensionName :
DimensionValue :
Name : cpu_percent
EndTime : 8/27/2015 5:22:25 PM
MetricValues : {Microsoft.Azure.Insights.Models.MetricValue, Microsoft.Azure.Insights.Models.MetricValue, Microsoft.Azure.Insights.Models.MetricValue, Microsoft.Azure.Insights.Models.MetricValue...}
Properties : {}
ResourceId : /subscriptions/00000000-0000-0000-0000-000000000001/resourceGroups/resourcegroup01/providers/Microsoft.Sql/servers/server01/elasticPools/elasticpool01
StartTime : 8/27/2015 4:20:00 PM
TimeGrain : 00:05:00
Unit : Percent
DimensionName :
DimensionValue :
Name : physical_data_read_percent
EndTime : 8/27/2015 5:22:25 PM
MetricValues : {Microsoft.Azure.Insights.Models.MetricValue, Microsoft.Azure.Insights.Models.MetricValue, Microsoft.Azure.Insights.Models.MetricValue, Microsoft.Azure.Insights.Models.MetricValue...}
Properties : {}
ResourceId : /subscriptions/00000000-0000-0000-0000-000000000001/resourceGroups/resourcegroup01/providers/Microsoft.Sql/servers/server01/elasticPools/elasticpool01
StartTime : 8/27/2015 4:20:00 PM
TimeGrain : 00:05:00
Unit : Percent
DimensionName :
DimensionValue :
Name : log_write_percent
EndTime : 8/27/2015 5:22:25 PM
MetricValues : {Microsoft.Azure.Insights.Models.MetricValue, Microsoft.Azure.Insights.Models.MetricValue, Microsoft.Azure.Insights.Models.MetricValue, Microsoft.Azure.Insights.Models.MetricValue...}
Properties : {}
ResourceId : /subscriptions/00000000-0000-0000-0000-000000000001/resourceGroups/resourcegroup01/providers/Microsoft.Sql/servers/server01/elasticPools/elasticpool01
StartTime : 8/27/2015 4:20:00 PM
TimeGrain : 00:05:00
Unit : Percent
DimensionName :
DimensionValue :
Name : dtu_consumption_percent
EndTime : 8/27/2015 5:22:25 PM
MetricValues : {Microsoft.Azure.Insights.Models.MetricValue, Microsoft.Azure.Insights.Models.MetricValue, Microsoft.Azure.Insights.Models.MetricValue, Microsoft.Azure.Insights.Models.MetricValue...}
Properties : {}
ResourceId : /subscriptions/00000000-0000-0000-0000-000000000001/resourceGroups/resourcegroup01/providers/Microsoft.Sql/servers/server01/elasticPools/elasticpool01
StartTime : 8/27/2015 4:20:00 PM
TimeGrain : 00:05:00
Unit : Percent
DimensionName :
DimensionValue :
Name : storage_percent
EndTime : 8/27/2015 5:22:25 PM
MetricValues : {Microsoft.Azure.Insights.Models.MetricValue, Microsoft.Azure.Insights.Models.MetricValue, Microsoft.Azure.Insights.Models.MetricValue, Microsoft.Azure.Insights.Models.MetricValue...}
Properties : {}
ResourceId : /subscriptions/00000000-0000-0000-0000-000000000001/resourceGroups/resourcegroup01/providers/Microsoft.Sql/servers/server01/elasticPools/elasticpool01
StartTime : 8/27/2015 4:20:00 PM
TimeGrain : 00:05:00
Unit : Percent
Questo comando restituisce le metriche per un pool di database elastici SQL di Azure denominato ElasticPool01.
Get-AzSqlElasticPool -ResourceGroupName "ResourceGroup01" -ServerName "Server01"
ResourceId : /subscriptions/00000000-0000-0000-0000-000000000001/resourceGroups/resourcegroup01/providers/Microsoft.Sql/servers/server01/elasticPools/elasticpool01
ResourceGroupName : resourcegroup01
ServerName : server01
ElasticPoolName : elasticpool01
Location : Central US
CreationDate : 8/26/2015 10:00:17 PM
State : Ready
Edition : Standard
Dtu : 400
DatabaseDtuMax : 100
DatabaseDtuMin : 10
StorageMB : 409600
Tags :
ResourceId : /subscriptions/00000000-0000-0000-0000-000000000001/resourceGroups/resourcegroup01/providers/Microsoft.Sql/servers/server01/elasticPools/elasticpool02
ResourceGroupName : resourcegroup01
ServerName : server01
ElasticPoolName : elasticpool02
Location : Central US
CreationDate : 8/26/2015 11:00:17 PM
State : Ready
Edition : Standard
Dtu : 400
DatabaseDtuMax : 100
DatabaseDtuMin : 10
StorageMB : 409600
Tags :
Questo comando ottiene tutti i pool elastici nel server denominato Server01 che iniziano con "ElasticPool".
Get-AzSqlElasticPool -ResourceGroupName "ResourceGroup01" -ServerName "Server01"
ResourceId : /subscriptions/00000000-0000-0000-0000-000000000001/resourceGroups/resourcegroup01/providers/Microsoft.Sql/servers/server01/elasticPools/elasticpool01
ResourceGroupName : resourcegroup01
ServerName : server01
ElasticPoolName : elasticpool01
Location : Central US
CreationDate : 8/26/2015 10:00:17 PM
State : Ready
Edition : Standard
Dtu : 400
DatabaseDtuMax : 100
DatabaseDtuMin : 10
StorageMB : 409600
PreferredEnclaveType : VBS
Tags :
Questo comando ottiene un pool elastico configurato con l'enclave VBS
Credenziali, account, tenant e sottoscrizione usati per la comunicazione con Azure
Tipo: | IAzureContextContainer |
Alias: | AzContext, AzureRmContext, AzureCredential |
Posizione: | Named |
Valore predefinito: | None |
Necessario: | False |
Accettare l'input della pipeline: | False |
Accettare caratteri jolly: | False |
Specifica il nome del pool elastico che ottiene questo cmdlet.
Tipo: | String |
Alias: | Name |
Posizione: | 2 |
Valore predefinito: | None |
Necessario: | False |
Accettare l'input della pipeline: | True |
Accettare caratteri jolly: | True |
Specifica il nome del gruppo di risorse che contiene il pool elastico che ottiene questo cmdlet.
Tipo: | String |
Posizione: | 0 |
Valore predefinito: | None |
Necessario: | True |
Accettare l'input della pipeline: | True |
Accettare caratteri jolly: | False |
Specifica il nome del server che contiene il pool elastico che ottiene questo cmdlet.
Tipo: | String |
Posizione: | 1 |
Valore predefinito: | None |
Necessario: | True |
Accettare l'input della pipeline: | True |
Accettare caratteri jolly: | False |
Feedback su Azure PowerShell
Azure PowerShell è un progetto di open source. Selezionare un collegamento per fornire feedback: