< Back
Get-AzureRmSqlElasticPoolRecommendation
Post
NAME Get-AzureRmSqlElasticPoolRecommendation
SYNOPSIS
Gets elastic pool recommendations.
SYNTAX
Get-AzureRmSqlElasticPoolRecommendation [-ResourceGroupName] <String> [-ServerName] <String> [-DefaultProfile <IAzureContextContainer>] [-Confirm]
[-WhatIf] [<CommonParameters>]
DESCRIPTION
The Get-AzureRmSqlElasticPoolRecommendation cmdlet gets elastic pool recommendations for a server. These recommendations include the following
values:
- DatabaseCollection. Collection of database names that belong to the pool.
- DatabaseDtuMin. Data Transmission Unit (DTU) guarantee for databases in the elastic pool.
-- DatabaseDtuMax. DTU cap for databases in the elastic pool. - Dtu. DTU guarantee for the elastic pool.
- StorageMb. Storage in megabytes for the elastic pool.
- Edition. Edition for the elastic pool. The acceptable values for this parameter are: Basic, Standard, and Premium.
- IncludeAllDatabases. Indicates whether to all databases in the elastic pool are returned.
- Name. Name of the elastic 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
-ResourceGroupName <String>
Specifies name of the resource group to which the server is assigned.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
Specifies the name of the server for which this cmdlet gets recommendations.
Required? true
Position? 1
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Prompts you for confirmation before running the cmdlet.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Required? false
Position? named
Default value False
Accept pipeline input? False
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
NOTES
Example 1: Get recommendations for a server
PS C:\\>Get-AzureRmSqlElasticPoolRecommendation -ResourceGroupName "ResourceGroup01" -ServerName "Server01"
This command gets the elastic pool recommendations for the server named Server01.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... mmendation
SYNOPSIS
Gets elastic pool recommendations.
SYNTAX
Get-AzureRmSqlElasticPoolRecommendation [-ResourceGroupName] <String> [-ServerName] <String> [-DefaultProfile <IAzureContextContainer>] [-Confirm]
[-WhatIf] [<CommonParameters>]
DESCRIPTION
The Get-AzureRmSqlElasticPoolRecommendation cmdlet gets elastic pool recommendations for a server. These recommendations include the following
values:
- DatabaseCollection. Collection of database names that belong to the pool.
- DatabaseDtuMin. Data Transmission Unit (DTU) guarantee for databases in the elastic pool.
-- DatabaseDtuMax. DTU cap for databases in the elastic pool. - Dtu. DTU guarantee for the elastic pool.
- StorageMb. Storage in megabytes for the elastic pool.
- Edition. Edition for the elastic pool. The acceptable values for this parameter are: Basic, Standard, and Premium.
- IncludeAllDatabases. Indicates whether to all databases in the elastic pool are returned.
- Name. Name of the elastic 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
-ResourceGroupName <String>
Specifies name of the resource group to which the server is assigned.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
Specifies the name of the server for which this cmdlet gets recommendations.
Required? true
Position? 1
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Prompts you for confirmation before running the cmdlet.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Required? false
Position? named
Default value False
Accept pipeline input? False
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
NOTES
Example 1: Get recommendations for a server
PS C:\\>Get-AzureRmSqlElasticPoolRecommendation -ResourceGroupName "ResourceGroup01" -ServerName "Server01"
This command gets the elastic pool recommendations for the server named Server01.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... mmendation