Set-AzureSqlElasticPool

Updated: September 1, 2015

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

Show: