pulumi-azure-kotlin/com.pulumi.azure.sql.kotlin/ElasticPoolArgs

ElasticPoolArgs

data class ElasticPoolArgs(val dbDtuMax: Output<Int>? = null, val dbDtuMin: Output<Int>? = null, val dtu: Output<Int>? = null, val edition: Output<String>? = null, val location: Output<String>? = null, val name: Output<String>? = null, val poolSize: Output<Int>? = null, val resourceGroupName: Output<String>? = null, val serverName: Output<String>? = null, val tags: Output<Map<String, String>>? = null) : ConvertibleToJava<ElasticPoolArgs>

Allows you to manage an Azure SQL Elastic Pool.

Note: The azure.sql.ElasticPool resource is deprecated in version 3.0 of the AzureRM provider and will be removed in version 4.0. Please use the azure.mssql.ElasticPool resource instead.

Example Usage

package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azure.core.ResourceGroup;
import com.pulumi.azure.core.ResourceGroupArgs;
import com.pulumi.azure.sql.SqlServer;
import com.pulumi.azure.sql.SqlServerArgs;
import com.pulumi.azure.sql.ElasticPool;
import com.pulumi.azure.sql.ElasticPoolArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }
    public static void stack(Context ctx) {
        var exampleResourceGroup = new ResourceGroup("exampleResourceGroup", ResourceGroupArgs.builder()
            .location("West Europe")
            .build());
        var exampleSqlServer = new SqlServer("exampleSqlServer", SqlServerArgs.builder()
            .resourceGroupName(exampleResourceGroup.name())
            .location(exampleResourceGroup.location())
            .version("12.0")
            .administratorLogin("4dm1n157r470r")
            .administratorLoginPassword("4-v3ry-53cr37-p455w0rd")
            .build());
        var exampleElasticPool = new ElasticPool("exampleElasticPool", ElasticPoolArgs.builder()
            .resourceGroupName(exampleResourceGroup.name())
            .location(exampleResourceGroup.location())
            .serverName(exampleSqlServer.name())
            .edition("Basic")
            .dtu(50)
            .dbDtuMin(0)
            .dbDtuMax(5)
            .poolSize(5000)
            .build());
    }
}

Import

SQL Elastic Pool's can be imported using the resource id, e.g.

$ pulumi import azure:sql/elasticPool:ElasticPool pool1 /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/myresourcegroup/providers/Microsoft.Sql/servers/myserver/elasticPools/pool1

Constructors

ElasticPoolArgs

fun ElasticPoolArgs(dbDtuMax: Output<Int>? = null, dbDtuMin: Output<Int>? = null, dtu: Output<Int>? = null, edition: Output<String>? = null, location: Output<String>? = null, name: Output<String>? = null, poolSize: Output<Int>? = null, resourceGroupName: Output<String>? = null, serverName: Output<String>? = null, tags: Output<Map<String, String>>? = null)

Functions

toJava

open override fun toJava(): ElasticPoolArgs

Properties

dbDtuMax

val dbDtuMax: Output<Int>? = null

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

dbDtuMin

val dbDtuMin: Output<Int>? = null

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

dtu

val dtu: Output<Int>? = null

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.

edition

val edition: Output<String>? = null

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.

location

val location: Output<String>? = null

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

name

val name: Output<String>? = null

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

poolSize

val poolSize: Output<Int>? = null

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.

resourceGroupName

val resourceGroupName: Output<String>? = null

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. Changing this forces a new resource to be created.

serverName

val serverName: Output<String>? = null

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