New-AzureSqlElasticPool
New-AzureSqlElasticPool
Creates an elastic database pool in Azure SQL Database.
Syntax
Parameter Set: Default
New-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 New-AzureSqlElasticPool cmdlet creates an elastic database pool in Azure SQL Database.
Parameters
-DatabaseDtuMax<System.Int32>
Specifies the maximum number of Database Throughput Units (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. Valid values are:
-- Premium
-- Basic
-- Standard
For the current preview, the edition must be Standard.
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 creates.
Aliases |
none |
Required? |
true |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
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 creates.
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 in which this cmdlet creates the elastic pool.
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. You cannot specify a value for this parameter for the Premium edition.
If you do not specify this parameter, this cmdlet calculates a value based on the value of the Dtu parameter. We recommend that you do not specify the StorageMB parameter.
If you specify StorageMB, but do not specify Dtu, the cmdlet calculates a value for Dtu. If you specify values for both, the values must be consistent. For more information about the relationship between storage and DTUs, see eDTU and storage limits for elastic pools and elastic databases.
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: Create an elastic pool
This command creates an elastic pool in the Standard service tier named ElasticPool27. The server named Server01 hosts the elastic pool in an Azure resource group named ResourceGroup11. The command specifies DTU property values for the pool and the databases in the pool.
PS C:\> New-AzureSqlElasticPool -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -ElasticPoolName "ElasticPool27" -Edition "Standard" -Dtu 400 -DatabaseDtuMin 10 -DatabaseDtuMax 100
Related topics
Get-AzureSqlElasticPoolActivity