Get-RedgateMonitorElasticPool
Published 18 April 2024
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 }}
Aliases | None |
Required? | false |
Position? | 1 |
Default Value | None |
Accept Pipeline Input | True (ByValue) |
Accept Wildcard Characters | false |
-Name
<String>
The Elastic Pool name to match.
Aliases | None |
Required? | false |
Position? | 2 |
Default Value | None |
Accept Pipeline Input | False |
Accept Wildcard Characters | false |
-ProgressAction
<ActionPreference>
{{ Fill ProgressAction Description }}
Aliases | None |
Required? | false |
Position? | named |
Default Value | None |
Accept Pipeline Input | False |
Accept Wildcard Characters | false |
<CommonParameters>
This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. 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.