Class ElasticPool

Allows you to manage an Azure SQL Elastic Pool.

NOTE: - This version of the Elasticpool resource is being deprecated and should no longer be used. Please use the azure.mssql.ElasticPool version instead.

Example Usage

using Pulumi;
using Azure = Pulumi.Azure;

class MyStack : Stack
{
public MyStack()
{
    var exampleResourceGroup = new Azure.Core.ResourceGroup("exampleResourceGroup", new Azure.Core.ResourceGroupArgs
    {
        Location = "West US",
    });
    var exampleSqlServer = new Azure.Sql.SqlServer("exampleSqlServer", new Azure.Sql.SqlServerArgs
    {
        ResourceGroupName = exampleResourceGroup.Name,
        Location = exampleResourceGroup.Location,
        Version = "12.0",
        AdministratorLogin = "4dm1n157r470r",
        AdministratorLoginPassword = "4-v3ry-53cr37-p455w0rd",
    });
    var exampleElasticPool = new Azure.Sql.ElasticPool("exampleElasticPool", new Azure.Sql.ElasticPoolArgs
    {
        ResourceGroupName = exampleResourceGroup.Name,
        Location = exampleResourceGroup.Location,
        ServerName = exampleSqlServer.Name,
        Edition = "Basic",
        Dtu = 50,
        DbDtuMin = 0,
        DbDtuMax = 5,
        PoolSize = 5000,
    });
}

}
Inheritance
System.Object
Resource
CustomResource
ElasticPool
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: Pulumi.Azure.Sql
Assembly: Pulumi.Azure.dll
Syntax
public class ElasticPool : CustomResource

Constructors

View Source

ElasticPool(String, ElasticPoolArgs, CustomResourceOptions)

Create a ElasticPool resource with the given unique name, arguments, and options.

Declaration
public ElasticPool(string name, ElasticPoolArgs args, CustomResourceOptions options = null)
Parameters
Type Name Description
System.String name

The unique name of the resource
ElasticPoolArgs args

The arguments used to populate this resource's properties
CustomResourceOptions options

A bag of options that control this resource's behavior

Properties

View Source

CreationDate

The creation date of the SQL Elastic Pool.

Declaration
public Output<string> CreationDate { get; }
Property Value
Type Description
Output<System.String>
View Source

DbDtuMax

The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.

Declaration
public Output<int> DbDtuMax { get; }
Property Value
Type Description
Output<System.Int32>
View Source

DbDtuMin

The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.

Declaration
public Output<int> DbDtuMin { get; }
Property Value
Type Description
Output<System.Int32>
View Source

Dtu

The total shared DTU for the elastic pool. Valid values depend on the edition which has been defined. Refer to Azure SQL Database Service Tiers for valid combinations.

Declaration
public Output<int> Dtu { get; }
Property Value
Type Description
Output<System.Int32>
View Source

Edition

The edition of the elastic pool to be created. Valid values are Basic, Standard, and Premium. Refer to Azure SQL Database Service Tiers for details. Changing this forces a new resource to be created.

Declaration
public Output<string> Edition { get; }
Property Value
Type Description
Output<System.String>
View Source

Location

Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.

Declaration
public Output<string> Location { get; }
Property Value
Type Description
Output<System.String>
View Source

Name

The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.

Declaration
public Output<string> Name { get; }
Property Value
Type Description
Output<System.String>
View Source

PoolSize

The maximum size in MB that all databases in the elastic pool can grow to. The maximum size must be consistent with combination of edition and dtu and the limits documented in Azure SQL Database Service Tiers. If not defined when creating an elastic pool, the value is set to the size implied by edition and dtu.

Declaration
public Output<int> PoolSize { get; }
Property Value
Type Description
Output<System.Int32>
View Source

ResourceGroupName

The name of the resource group in which to create the elastic pool. This must be the same as the resource group of the underlying SQL server.

Declaration
public Output<string> ResourceGroupName { get; }
Property Value
Type Description
Output<System.String>
View Source

ServerName

The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.

Declaration
public Output<string> ServerName { get; }
Property Value
Type Description
Output<System.String>
View Source

Tags

A mapping of tags to assign to the resource.

Declaration
public Output<ImmutableDictionary<string, string>> Tags { get; }
Property Value
Type Description
Output<System.Collections.Immutable.ImmutableDictionary<System.String, System.String>>

Methods

View Source

Get(String, Input<String>, ElasticPoolState, CustomResourceOptions)

Get an existing ElasticPool resource's state with the given name, ID, and optional extra properties used to qualify the lookup.

Declaration
public static ElasticPool Get(string name, Input<string> id, ElasticPoolState state = null, CustomResourceOptions options = null)
Parameters
Type Name Description
System.String name

The unique name of the resulting resource.
Input<System.String> id

The unique provider ID of the resource to lookup.
ElasticPoolState state

Any extra arguments used during the lookup.
CustomResourceOptions options

A bag of options that control this resource's behavior
Returns
Type Description
ElasticPool