New-​Azure​Rm​Sql​Elastic​Pool

Creates an elastic database pool for a SQL Database.

Syntax

New-AzureRmSqlElasticPool
   [-ResourceGroupName] <String>
   [-ServerName] <String>
   [-DatabaseDtuMax <Int32>]
   [-DatabaseDtuMin <Int32>]
   [-Dtu <Int32>]
   [-Edition <DatabaseEdition>]
   -ElasticPoolName <String>
   [-StorageMB <Int32>]
   [-Tags <Hashtable>]
   [-Confirm]
   [-WhatIf]
   [<CommonParameters>]

Description

The New-AzureRmSqlElasticPool cmdlet creates an elastic database pool for an Azure SQL Database.

Examples

Example 1: Create an elastic pool

PS C:\>New-AzureRmSqlElasticPool -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ElasticPoolName "ElasticPool01" -Edition "Standard" -Dtu 400 -DatabaseDtuMin 10 -DatabaseDtuMax 100
ResourceId        : /subscriptions/00000000-0000-0000-0000-000000000001/resourceGroups/resourcegroup01/providers/Microsoft.Sql/servers/server01/elasticPools/elasticpool01
ResourceGroupName : resourcegroup01
ServerName        : server01
ElasticPoolName   : elasticpool01
Location          : Central US
CreationDate      : 8/26/2015 10:00:17 PM
State             : Ready
Edition           : Standard
Dtu               : 400
DatabaseDtuMax    : 100
DatabaseDtuMin    : 10
StorageMB         : 409600
Tags              :

This command creates an elastic pool in the Standard service tier named ElasticPool01. The server named server01, assigned to an Azure resource group named ResourceGroup01, hosts the elastic pool in. The command specifies DTU property values for the pool and the databases in the pool.

Required Parameters

-ElasticPoolName

Specifies the name of the elastic pool that this cmdlet creates.

Type:String
Aliases:Name
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-ResourceGroupName

Specifies the name of the resource group to which this cmdlet assigns the elastic pool.

Type:String
Position:0
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-ServerName

Specifies the name of the server that hosts the elastic pool.

Type:String
Position:1
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

Optional Parameters

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False
-DatabaseDtuMax

Specifies the maximum number of Database Throughput Units (DTUs) that any single database in the pool can consume. The default values for the different editions are as follows:

  • Basic. 5 DTUs
  • Standard. 100 DTUs
  • Premium. 125 DTUs
Type:Int32
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-DatabaseDtuMin

Specifies the minimum number of DTUs that the elastic pool guarantees to all the databases in the pool. The default value is zero (0).

Type:Int32
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Dtu

Specifies the total number of shared DTUs for the elastic pool. The default values for the different editions are as follows:

  • Basic. 100 DTUs
  • Standard. 100 DTUs
  • Premium. 125 DTUs
Type:Int32
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Edition

Specifies the edition of the Azure SQL Database used for the elastic pool. The acceptable values for this parameter are:

  • Premium
  • Basic
  • Standard
Type:DatabaseEdition
Parameter Sets:None, Premium, Basic, Standard, DataWarehouse, Stretch, Free, PremiumRS
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-StorageMB

Specifies the storage limit, in megabytes, for the elastic pool. If you do not specify this parameter, this cmdlet calculates a value that depends on the value of the Dtu parameter.

See eDTU and storage limits for possible values.

Type:Int32
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Tags

Specifies a dictionary of tags that this cmdlet associates with the elastic pool.

Type:Hashtable
Aliases:Tag
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False

Outputs

Microsoft.Azure.Commands.Sql.ElasticPool.Model.AzureSqlElasticPoolModel