Set-AzureSqlElasticPool
Set-AzureSqlElasticPool
Modifies properties for an elastic database pool in Azure SQL Database.
Syntax
Parameter Set: Default
Set-AzureSqlElasticPool [-ResourceGroupName] <System.String> [-ServerName] <System.String> [-ElasticPoolName] <System.String> [-DatabaseDtuMax <System.Int32> ] [-DatabaseDtuMin <System.Int32> ] [-Dtu <System.Int32> ] [-Edition <Microsoft.Azure.Commands.Sql.Database.Model.DatabaseEdition> {None | Premium | Basic | Standard | DataWarehouse} ] [-Profile <Microsoft.Azure.Common.Authentication.Models.AzureProfile> ] [-StorageMB <Int32> ] [-Tags <System.Collections.Generic.Dictionary`2[[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]> ]
Detailed Description
The Set-AzureSqlElasticPool cmdlet modifies properties for an elastic database pool in Azure SQL Database. This cmdlet can modify the minimum Database Throughput Units (DTUs) per database, and the maximum DTUs per database, the number of DTUs for the pool, and the storage limit for the pool.
Parameters
-DatabaseDtuMax<System.Int32>
Specifies the maximum number of DTUs that any single database in the pool can consume. The default values for different editions are as follows:
-- Basic. 5 DTUs
-- Standard. 100 DTUs
-- Premium. 125 DTUs
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-DatabaseDtuMin<System.Int32>
Specifies the minimum number of DTUs that the elastic pool guarantees to all the databases in the pool. The default value is zero (0).
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-Dtu<System.Int32>
Specifies the total number of shared DTUs for the elastic pool. The default values for different editions are as follows:
-- Basic. 100 DTUs
-- Standard. 100 DTUs
-- Premium. 125 DTUs
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-Edition<Microsoft.Azure.Commands.Sql.Database.Model.DatabaseEdition>
Specifies the edition of Azure SQL Database for the elastic pool. You cannot change the edition.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-ElasticPoolName<System.String>
Specifies the name of the elastic pool that this cmdlet modifies.
Aliases |
none |
Required? |
true |
Position? |
3 |
Default Value |
none |
Accept Pipeline Input? |
true(ByPropertyName) |
Accept Wildcard Characters? |
false |
-Profile<Microsoft.Azure.Common.Authentication.Models.AzureProfile>
Specifies the Azure profile from which this cmdlet reads. If you do not specify a profile, this cmdlet reads from the local default profile.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-ResourceGroupName<System.String>
Specifies the name of the resource group that contains the elastic pool that this cmdlet modifies.
Aliases |
none |
Required? |
true |
Position? |
1 |
Default Value |
none |
Accept Pipeline Input? |
true(ByPropertyName) |
Accept Wildcard Characters? |
false |
-ServerName<System.String>
Specifies the name of the server that contains the elastic pool that this cmdlet updates.
Aliases |
none |
Required? |
true |
Position? |
2 |
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-AzureSqlElasticPool cmdlet.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-Tags<System.Collections.Generic.Dictionary`2[[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]>
Specifies a dictionary of tags that this cmdlet associates with the elastic pool.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
Inputs
The input type is the type of the objects that you can pipe to the cmdlet.
- System.String
Outputs
The output type is the type of the objects that the cmdlet emits.
- System.Object
Notes
- This cmdlet supports the common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, OutBuffer, PipelineVariable, and OutVariable. For more information, see about_CommonParameters.
Examples
Example 1: Modify properties for an elastic pool
This command modifies properties for an elastic pool named ElasticPool27. The command sets the number of DTUs for the elastic pool to be 1000 and sets the minimum and maximum DTUs.
PS C:\> Set-AzureSqlDatabaseElasticPool -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -ElasticPoolName "ElasticPool27" -Dtu 1000 -DatabaseDtuMax 100 -DatabaseDtuMin 20
Related topics
Get-AzureSqlElasticPoolActivity