< Back
Set-AzureRmSqlElasticPool
Post
NAME Set-AzureRmSqlElasticPool
SYNOPSIS
Modifies properties of an elastic database pool in Azure SQL Database.
SYNTAX
Set-AzureRmSqlElasticPool [-ResourceGroupName] <String> [-ServerName] <String> [-ElasticPoolName] <String> [-AsJob] [-DatabaseDtuMax <Int32>]
[-DatabaseDtuMin <Int32>] [-DefaultProfile <IAzureContextContainer>] [-Dtu <Int32>] [-Edition {None | Premium | Basic | Standard | DataWarehouse |
Stretch | Free | PremiumRS}] [-StorageMB <Int32>] [-Tags <Hashtable>] [-ZoneRedundant] [-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The Set-AzureRmSqlElasticPool cmdlet sets properties for an elastic pool in Azure SQL Database. This cmdlet can modify the eDTUs per pool ( Dtu ),
storage max size per pool ( StorageMB ), maximum eDTUs per database ( DatabaseDtuMax ), and minimum eDTUs per database ( DatqabaseDtuMin ).
Several parameters ( -Dtu, -DatabaseDtuMin, and -DatabaseDtuMax ) require the value being set is from the list of valid values for that parameter.
For example, -DatabaseDtuMax for a Standard 100 eDTU pool can only be set to 10, 20, 50, or 100. For details about which values are valid, see
the table for your specific size pool in elastic pools (https://docs.microsoft.com/azure/sql-da ... astic-pool).
PARAMETERS
-AsJob [<SwitchParameter>]
Run cmdlet in the background
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-DatabaseDtuMax <Int32>
Specifies the maximum number of DTUs that any single database in the pool can consume.
For details about which values are valid, see the table for your specific size pool in elastic pools
(https://docs.microsoft.com/azure/sql-da ... astic-pool).
The default values for different editions are as follows:
- Basic. 5 DTUs
- Standard. 100 DTUs
- Premium. 125 DTUs
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-DatabaseDtuMin <Int32>
Specifies the minimum number of DTUs that the elastic pool guarantees to all the databases in the pool.
For details about which values are valid, see the table for your specific size pool in elastic pools
(https://docs.microsoft.com/azure/sql-da ... astic-pool).
The default value is zero (0).
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-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
-Dtu <Int32>
Specifies the total number of shared DTUs for the elastic pool.
For details about which values are valid, see the table for your specific size pool in elastic pools
(https://docs.microsoft.com/azure/sql-da ... astic-pool).
The default values for different editions are as follows:
- Basic. 100 DTUs
- Standard. 100 DTUs
- Premium. 125 DTUs
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-Edition <DatabaseEdition>
Specifies the edition of the Azure SQL Database for the elastic pool. You cannot change the edition. The acceptable values for this parameter
are:
- None
- Basic
- Standard
- Premium
- DataWarehouse
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ElasticPoolName <String>
Specifies the name of the elastic pool.
Required? true
Position? 2
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of the resource group to which the elastic pool 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 that hosts the elastic pool.
Required? true
Position? 1
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-StorageMB <Int32>
Specifies the storage limit, in megabytes, for the elastic pool. For more information, see the New-AzureRmSqlElasticPool cmdlet.
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-Tags <Hashtable>
Specifies a dictionary of Key-value pairs that this cmdlet associates with the elastic pool in the form of a hash table. For example:
`@{key0="value0";"key 1"=$null;key2="value2"}`
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ZoneRedundant [<SwitchParameter>]
The zone redundancy to associate with the Azure Sql Elastic Pool
Required? false
Position? named
Default value False
Accept pipeline input? False
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
Microsoft.Azure.Commands.Sql.ElasticPool.Model.AzureSqlElasticPoolModel
NOTES
Example 1: Modify properties for an elastic pool
PS C:\\>Set-AzureRmSqlDatabaseElasticPool -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ElasticPoolName "ElasticPool01" -Dtu 1000
-DatabaseDtuMax 100 -DatabaseDtuMin 20
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 : 200
DatabaseDtuMax : 100
DatabaseDtuMin : 20
StorageMB : 204800
Tags :
This command modifies properties for an elastic pool named elasticpool01. The command sets the number of DTUs for the elastic pool to 1000 and
sets the minimum and maximum DTUs.
Example 2: Modify the storage max size of an elastic pool
PS C:\\>Set-AzureRmSqlDatabaseElasticPool -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ElasticPoolName "ElasticPool01" -StorageMB
2097152
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 : Premium
Dtu : 200
DatabaseDtuMax : 100
DatabaseDtuMin : 20
StorageMB : 2097152
Tags :
This command modifies properties for an elastic pool named elasticpool01. The command sets the max storage for an elastic pool to 2 TB.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... lasticpool
Get-AzureRmSqlElasticPool
Get-AzureRmSqlElasticPoolActivity
Get-AzureRmSqlElasticPoolDatabase
New-AzureRmSqlElasticPool
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/
SYNOPSIS
Modifies properties of an elastic database pool in Azure SQL Database.
SYNTAX
Set-AzureRmSqlElasticPool [-ResourceGroupName] <String> [-ServerName] <String> [-ElasticPoolName] <String> [-AsJob] [-DatabaseDtuMax <Int32>]
[-DatabaseDtuMin <Int32>] [-DefaultProfile <IAzureContextContainer>] [-Dtu <Int32>] [-Edition {None | Premium | Basic | Standard | DataWarehouse |
Stretch | Free | PremiumRS}] [-StorageMB <Int32>] [-Tags <Hashtable>] [-ZoneRedundant] [-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The Set-AzureRmSqlElasticPool cmdlet sets properties for an elastic pool in Azure SQL Database. This cmdlet can modify the eDTUs per pool ( Dtu ),
storage max size per pool ( StorageMB ), maximum eDTUs per database ( DatabaseDtuMax ), and minimum eDTUs per database ( DatqabaseDtuMin ).
Several parameters ( -Dtu, -DatabaseDtuMin, and -DatabaseDtuMax ) require the value being set is from the list of valid values for that parameter.
For example, -DatabaseDtuMax for a Standard 100 eDTU pool can only be set to 10, 20, 50, or 100. For details about which values are valid, see
the table for your specific size pool in elastic pools (https://docs.microsoft.com/azure/sql-da ... astic-pool).
PARAMETERS
-AsJob [<SwitchParameter>]
Run cmdlet in the background
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-DatabaseDtuMax <Int32>
Specifies the maximum number of DTUs that any single database in the pool can consume.
For details about which values are valid, see the table for your specific size pool in elastic pools
(https://docs.microsoft.com/azure/sql-da ... astic-pool).
The default values for different editions are as follows:
- Basic. 5 DTUs
- Standard. 100 DTUs
- Premium. 125 DTUs
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-DatabaseDtuMin <Int32>
Specifies the minimum number of DTUs that the elastic pool guarantees to all the databases in the pool.
For details about which values are valid, see the table for your specific size pool in elastic pools
(https://docs.microsoft.com/azure/sql-da ... astic-pool).
The default value is zero (0).
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-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
-Dtu <Int32>
Specifies the total number of shared DTUs for the elastic pool.
For details about which values are valid, see the table for your specific size pool in elastic pools
(https://docs.microsoft.com/azure/sql-da ... astic-pool).
The default values for different editions are as follows:
- Basic. 100 DTUs
- Standard. 100 DTUs
- Premium. 125 DTUs
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-Edition <DatabaseEdition>
Specifies the edition of the Azure SQL Database for the elastic pool. You cannot change the edition. The acceptable values for this parameter
are:
- None
- Basic
- Standard
- Premium
- DataWarehouse
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ElasticPoolName <String>
Specifies the name of the elastic pool.
Required? true
Position? 2
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of the resource group to which the elastic pool 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 that hosts the elastic pool.
Required? true
Position? 1
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-StorageMB <Int32>
Specifies the storage limit, in megabytes, for the elastic pool. For more information, see the New-AzureRmSqlElasticPool cmdlet.
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-Tags <Hashtable>
Specifies a dictionary of Key-value pairs that this cmdlet associates with the elastic pool in the form of a hash table. For example:
`@{key0="value0";"key 1"=$null;key2="value2"}`
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ZoneRedundant [<SwitchParameter>]
The zone redundancy to associate with the Azure Sql Elastic Pool
Required? false
Position? named
Default value False
Accept pipeline input? False
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
Microsoft.Azure.Commands.Sql.ElasticPool.Model.AzureSqlElasticPoolModel
NOTES
Example 1: Modify properties for an elastic pool
PS C:\\>Set-AzureRmSqlDatabaseElasticPool -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ElasticPoolName "ElasticPool01" -Dtu 1000
-DatabaseDtuMax 100 -DatabaseDtuMin 20
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 : 200
DatabaseDtuMax : 100
DatabaseDtuMin : 20
StorageMB : 204800
Tags :
This command modifies properties for an elastic pool named elasticpool01. The command sets the number of DTUs for the elastic pool to 1000 and
sets the minimum and maximum DTUs.
Example 2: Modify the storage max size of an elastic pool
PS C:\\>Set-AzureRmSqlDatabaseElasticPool -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ElasticPoolName "ElasticPool01" -StorageMB
2097152
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 : Premium
Dtu : 200
DatabaseDtuMax : 100
DatabaseDtuMin : 20
StorageMB : 2097152
Tags :
This command modifies properties for an elastic pool named elasticpool01. The command sets the max storage for an elastic pool to 2 TB.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... lasticpool
Get-AzureRmSqlElasticPool
Get-AzureRmSqlElasticPoolActivity
Get-AzureRmSqlElasticPoolDatabase
New-AzureRmSqlElasticPool
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/