Gets the details of all of the Elastic Pools for the given Azure SQL Server.

Syntax

Get-RedgateMonitorElasticPool [[-AzureSqlServer] <AzureSqlServer>] [[-Name] <string>] [<CommonParameters>]

Description

The Get-RedgateMonitorElasticPool cmdlet gets details of Elastic Pools from a Redgate Monitor Server.

Without parameters, this cmdlet gets details of all Elastic Pools.

Connect-RedgateMonitor must be called before this cmdlet.

Parameters

-AzureSqlServer <AzureSqlServer>

{{ Fill AzureSqlServer Description }}

-Name <String>

The Elastic Pool name to match.

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, -OutVariable, and -ProgressAction. For more information, see http://technet.microsoft.com/en-us/library/hh847884.aspx.

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

• [AzureSqlServer] For more information, see https://www.red-gate.com/monitor14/powershell-custom-types#CustomTypes-AzureSqlServer.

Return values

The output type is the type of the objects that the cmdlet emits.

• [ElasticPool] For more information, see https://www.red-gate.com/monitor14/powershell-custom-types#CustomTypes-ElasticPool.

Examples

-------------------------- EXAMPLE 1 --------------------------

Get-RedgateMonitorElasticPool

This command will get all elastic pools from Redgate Monitor Server.

-------------------------- EXAMPLE 2 --------------------------

Get-RedgateMonitorElasticPool -AzureSqlServer $azureSqlServer

This command will get all elastic pools on the specified Azure SQL Server from Redgate Monitor Server.

-------------------------- EXAMPLE 3 --------------------------

Get-RedgateMonitorElasticPool -Name "ExampleElasticPoolName"

This command will get all elastic pools with the name "ExampleElasticPoolName" from Redgate Monitor Server.

-------------------------- EXAMPLE 4 --------------------------

Get-RedgateMonitorElasticPool -AzureSqlServer $azureSqlServer -Name "ExampleElasticPoolName"

This command will get all elastic pools with the name "ExampleElasticPoolName" on the specified Azure SQL Server from Redgate Monitor Server.