Get-AzureRmSqlElasticPool

NAME Get-AzureRmSqlElasticPool



SYNOPSIS

Gets elastic pools and their property values in an Azure SQL Database.





SYNTAX

Get-AzureRmSqlElasticPool [-ResourceGroupName] <String> [-ServerName] <String> [[-ElasticPoolName] <String>] [-DefaultProfile

<IAzureContextContainer>] [<CommonParameters>]





DESCRIPTION

The Get-AzureRmSqlElasticPool cmdlet gets elastic pools and their property values. Specify the name of an existing elastic pool to see the

property values for only that pool.





PARAMETERS

-DefaultProfile <IAzureContextContainer>

The credentials, account, tenant, and subscription used for communication with azure



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-ElasticPoolName <String>

Specifies the name of the elastic pool that this cmdlet gets.



Required? false

Position? 2

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ResourceGroupName <String>

Specifies the name of the resource group that contains the elastic pool that this cmdlet gets.



Required? true

Position? 0

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ServerName <String>

Specifies the name of the server that contains the elastic pool that this cmdlet gets.



Required? true

Position? 1

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).



INPUTS

None

This cmdlet does not accept any input.





OUTPUTS

Microsoft.Azure.Commands.Sql.ElasticPool.Model.AzureSqlElasticPoolModel







NOTES









Example 1: Get all elastic pools



PS C:\\>Get-AzureRmSqlElasticPool -ResourceGroupName "ResourceGroup01" -ServerName "Server01"

ResourceId : /subscriptions/00000000-0000-0000-0000-000000000001/resourceGroups/resourcegroup01/providers/Microsoft.Sql/servers/server01/ela

sticPools/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/ela

sticPools/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 :



This command gets all of the elastic pools on the server named Server01.





Example 2: Get a specific elastic pool



PS C:\\>Get-AzureRmSqlElasticPool -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ElasticPoolName "ElasticPool27"

ResourceId : /subscriptions/00000000-0000-0000-0000-000000000001/resourceGroups/resourcegroup01/providers/Microsoft.Sql/servers/server01/ela

sticPools/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 :



This command gets the elastic pool named ElasticPool0127 on the server named Server01.





Example 3: Get metrics for a Azure SQL Elastic Database Pool



PS C:\\>Get-AzureRmSqlElasticPool -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ElasticPoolName "ElasticPool01" | Get-Metrics

-TimeGrain 0:5:0

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/elasti

cPools/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/elasti

cPools/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/elasti

cPools/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/elasti

cPools/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/elasti

cPools/elasticpool01

StartTime : 8/27/2015 4:20:00 PM

TimeGrain : 00:05:00

Unit : Percent



This command returns metrics for an Azure SQL elastic database pool named ElasticPool01.







RELATED LINKS

Online Version: https://docs.microsoft.com/en-us/powers ... lasticpool

New-AzureRmSqlElasticPool

Remove-AzureRmSqlElasticPool

Set-AzureRmSqlElasticPool