We recommend using Azure Native.
azure.sql.ElasticPool
Explore with Pulumi AI
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 theazure.mssql.ElasticPool
resource instead.
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";
const example = new azure.core.ResourceGroup("example", {
name: "my-resource-group",
location: "West Europe",
});
const exampleSqlServer = new azure.sql.SqlServer("example", {
name: "my-sql-server",
resourceGroupName: example.name,
location: example.location,
version: "12.0",
administratorLogin: "4dm1n157r470r",
administratorLoginPassword: "4-v3ry-53cr37-p455w0rd",
});
const exampleElasticPool = new azure.sql.ElasticPool("example", {
name: "test",
resourceGroupName: example.name,
location: example.location,
serverName: exampleSqlServer.name,
edition: "Basic",
dtu: 50,
dbDtuMin: 0,
dbDtuMax: 5,
poolSize: 5000,
});
import pulumi
import pulumi_azure as azure
example = azure.core.ResourceGroup("example",
name="my-resource-group",
location="West Europe")
example_sql_server = azure.sql.SqlServer("example",
name="my-sql-server",
resource_group_name=example.name,
location=example.location,
version="12.0",
administrator_login="4dm1n157r470r",
administrator_login_password="4-v3ry-53cr37-p455w0rd")
example_elastic_pool = azure.sql.ElasticPool("example",
name="test",
resource_group_name=example.name,
location=example.location,
server_name=example_sql_server.name,
edition="Basic",
dtu=50,
db_dtu_min=0,
db_dtu_max=5,
pool_size=5000)
package main
import (
"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/core"
"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/sql"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
example, err := core.NewResourceGroup(ctx, "example", &core.ResourceGroupArgs{
Name: pulumi.String("my-resource-group"),
Location: pulumi.String("West Europe"),
})
if err != nil {
return err
}
exampleSqlServer, err := sql.NewSqlServer(ctx, "example", &sql.SqlServerArgs{
Name: pulumi.String("my-sql-server"),
ResourceGroupName: example.Name,
Location: example.Location,
Version: pulumi.String("12.0"),
AdministratorLogin: pulumi.String("4dm1n157r470r"),
AdministratorLoginPassword: pulumi.String("4-v3ry-53cr37-p455w0rd"),
})
if err != nil {
return err
}
_, err = sql.NewElasticPool(ctx, "example", &sql.ElasticPoolArgs{
Name: pulumi.String("test"),
ResourceGroupName: example.Name,
Location: example.Location,
ServerName: exampleSqlServer.Name,
Edition: pulumi.String("Basic"),
Dtu: pulumi.Int(50),
DbDtuMin: pulumi.Int(0),
DbDtuMax: pulumi.Int(5),
PoolSize: pulumi.Int(5000),
})
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Azure = Pulumi.Azure;
return await Deployment.RunAsync(() =>
{
var example = new Azure.Core.ResourceGroup("example", new()
{
Name = "my-resource-group",
Location = "West Europe",
});
var exampleSqlServer = new Azure.Sql.SqlServer("example", new()
{
Name = "my-sql-server",
ResourceGroupName = example.Name,
Location = example.Location,
Version = "12.0",
AdministratorLogin = "4dm1n157r470r",
AdministratorLoginPassword = "4-v3ry-53cr37-p455w0rd",
});
var exampleElasticPool = new Azure.Sql.ElasticPool("example", new()
{
Name = "test",
ResourceGroupName = example.Name,
Location = example.Location,
ServerName = exampleSqlServer.Name,
Edition = "Basic",
Dtu = 50,
DbDtuMin = 0,
DbDtuMax = 5,
PoolSize = 5000,
});
});
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 example = new ResourceGroup("example", ResourceGroupArgs.builder()
.name("my-resource-group")
.location("West Europe")
.build());
var exampleSqlServer = new SqlServer("exampleSqlServer", SqlServerArgs.builder()
.name("my-sql-server")
.resourceGroupName(example.name())
.location(example.location())
.version("12.0")
.administratorLogin("4dm1n157r470r")
.administratorLoginPassword("4-v3ry-53cr37-p455w0rd")
.build());
var exampleElasticPool = new ElasticPool("exampleElasticPool", ElasticPoolArgs.builder()
.name("test")
.resourceGroupName(example.name())
.location(example.location())
.serverName(exampleSqlServer.name())
.edition("Basic")
.dtu(50)
.dbDtuMin(0)
.dbDtuMax(5)
.poolSize(5000)
.build());
}
}
resources:
example:
type: azure:core:ResourceGroup
properties:
name: my-resource-group
location: West Europe
exampleSqlServer:
type: azure:sql:SqlServer
name: example
properties:
name: my-sql-server
resourceGroupName: ${example.name}
location: ${example.location}
version: '12.0'
administratorLogin: 4dm1n157r470r
administratorLoginPassword: 4-v3ry-53cr37-p455w0rd
exampleElasticPool:
type: azure:sql:ElasticPool
name: example
properties:
name: test
resourceGroupName: ${example.name}
location: ${example.location}
serverName: ${exampleSqlServer.name}
edition: Basic
dtu: 50
dbDtuMin: 0
dbDtuMax: 5
poolSize: 5000
NOTE on
azure.sql.ElasticPool
: - The values ofedition
,dtu
, andpool_size
must be consistent with the Azure SQL Database Service Tiers. Any inconsistent argument configuration will be rejected.
Create ElasticPool Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new ElasticPool(name: string, args: ElasticPoolArgs, opts?: CustomResourceOptions);
@overload
def ElasticPool(resource_name: str,
args: ElasticPoolArgs,
opts: Optional[ResourceOptions] = None)
@overload
def ElasticPool(resource_name: str,
opts: Optional[ResourceOptions] = None,
dtu: Optional[int] = None,
edition: Optional[str] = None,
resource_group_name: Optional[str] = None,
server_name: Optional[str] = None,
db_dtu_max: Optional[int] = None,
db_dtu_min: Optional[int] = None,
location: Optional[str] = None,
name: Optional[str] = None,
pool_size: Optional[int] = None,
tags: Optional[Mapping[str, str]] = None)
func NewElasticPool(ctx *Context, name string, args ElasticPoolArgs, opts ...ResourceOption) (*ElasticPool, error)
public ElasticPool(string name, ElasticPoolArgs args, CustomResourceOptions? opts = null)
public ElasticPool(String name, ElasticPoolArgs args)
public ElasticPool(String name, ElasticPoolArgs args, CustomResourceOptions options)
type: azure:sql:ElasticPool
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name string
- The unique name of the resource.
- args ElasticPoolArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name str
- The unique name of the resource.
- args ElasticPoolArgs
- The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name string
- The unique name of the resource.
- args ElasticPoolArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args ElasticPoolArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args ElasticPoolArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
Constructor example
The following reference example uses placeholder values for all input properties.
var azureElasticPoolResource = new Azure.Sql.ElasticPool("azureElasticPoolResource", new()
{
Dtu = 0,
Edition = "string",
ResourceGroupName = "string",
ServerName = "string",
DbDtuMax = 0,
DbDtuMin = 0,
Location = "string",
Name = "string",
PoolSize = 0,
Tags =
{
{ "string", "string" },
},
});
example, err := sql.NewElasticPool(ctx, "azureElasticPoolResource", &sql.ElasticPoolArgs{
Dtu: pulumi.Int(0),
Edition: pulumi.String("string"),
ResourceGroupName: pulumi.String("string"),
ServerName: pulumi.String("string"),
DbDtuMax: pulumi.Int(0),
DbDtuMin: pulumi.Int(0),
Location: pulumi.String("string"),
Name: pulumi.String("string"),
PoolSize: pulumi.Int(0),
Tags: pulumi.StringMap{
"string": pulumi.String("string"),
},
})
var azureElasticPoolResource = new ElasticPool("azureElasticPoolResource", ElasticPoolArgs.builder()
.dtu(0)
.edition("string")
.resourceGroupName("string")
.serverName("string")
.dbDtuMax(0)
.dbDtuMin(0)
.location("string")
.name("string")
.poolSize(0)
.tags(Map.of("string", "string"))
.build());
azure_elastic_pool_resource = azure.sql.ElasticPool("azureElasticPoolResource",
dtu=0,
edition="string",
resource_group_name="string",
server_name="string",
db_dtu_max=0,
db_dtu_min=0,
location="string",
name="string",
pool_size=0,
tags={
"string": "string",
})
const azureElasticPoolResource = new azure.sql.ElasticPool("azureElasticPoolResource", {
dtu: 0,
edition: "string",
resourceGroupName: "string",
serverName: "string",
dbDtuMax: 0,
dbDtuMin: 0,
location: "string",
name: "string",
poolSize: 0,
tags: {
string: "string",
},
});
type: azure:sql:ElasticPool
properties:
dbDtuMax: 0
dbDtuMin: 0
dtu: 0
edition: string
location: string
name: string
poolSize: 0
resourceGroupName: string
serverName: string
tags:
string: string
ElasticPool Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
The ElasticPool resource accepts the following input properties:
- Dtu int
- 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 string
- The edition of the elastic pool to be created. Valid values are
Basic
,Standard
, andPremium
. Refer to Azure SQL Database Service Tiers for details. Changing this forces a new resource to be created. - Resource
Group stringName - 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.
- Server
Name string - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- Db
Dtu intMax - The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.
- Db
Dtu intMin - The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.
- Location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- Name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- Pool
Size int - 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
anddtu
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 byedition
anddtu
. - Dictionary<string, string>
- A mapping of tags to assign to the resource.
- Dtu int
- 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 string
- The edition of the elastic pool to be created. Valid values are
Basic
,Standard
, andPremium
. Refer to Azure SQL Database Service Tiers for details. Changing this forces a new resource to be created. - Resource
Group stringName - 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.
- Server
Name string - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- Db
Dtu intMax - The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.
- Db
Dtu intMin - The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.
- Location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- Name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- Pool
Size int - 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
anddtu
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 byedition
anddtu
. - map[string]string
- A mapping of tags to assign to the resource.
- dtu Integer
- 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 String
- The edition of the elastic pool to be created. Valid values are
Basic
,Standard
, andPremium
. Refer to Azure SQL Database Service Tiers for details. Changing this forces a new resource to be created. - resource
Group StringName - 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.
- server
Name String - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- db
Dtu IntegerMax - The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.
- db
Dtu IntegerMin - The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.
- location String
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- name String
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- pool
Size Integer - 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
anddtu
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 byedition
anddtu
. - Map<String,String>
- A mapping of tags to assign to the resource.
- dtu number
- 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 string
- The edition of the elastic pool to be created. Valid values are
Basic
,Standard
, andPremium
. Refer to Azure SQL Database Service Tiers for details. Changing this forces a new resource to be created. - resource
Group stringName - 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.
- server
Name string - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- db
Dtu numberMax - The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.
- db
Dtu numberMin - The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.
- location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- pool
Size number - 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
anddtu
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 byedition
anddtu
. - {[key: string]: string}
- A mapping of tags to assign to the resource.
- dtu int
- 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 str
- The edition of the elastic pool to be created. Valid values are
Basic
,Standard
, andPremium
. Refer to Azure SQL Database Service Tiers for details. Changing this forces a new resource to be created. - resource_
group_ strname - 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.
- server_
name str - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- db_
dtu_ intmax - The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.
- db_
dtu_ intmin - The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.
- location str
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- name str
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- pool_
size int - 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
anddtu
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 byedition
anddtu
. - Mapping[str, str]
- A mapping of tags to assign to the resource.
- dtu Number
- 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 String
- The edition of the elastic pool to be created. Valid values are
Basic
,Standard
, andPremium
. Refer to Azure SQL Database Service Tiers for details. Changing this forces a new resource to be created. - resource
Group StringName - 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.
- server
Name String - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- db
Dtu NumberMax - The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.
- db
Dtu NumberMin - The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.
- location String
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- name String
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- pool
Size Number - 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
anddtu
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 byedition
anddtu
. - Map<String>
- A mapping of tags to assign to the resource.
Outputs
All input properties are implicitly available as output properties. Additionally, the ElasticPool resource produces the following output properties:
- Creation
Date string - The creation date of the SQL Elastic Pool.
- Id string
- The provider-assigned unique ID for this managed resource.
- Creation
Date string - The creation date of the SQL Elastic Pool.
- Id string
- The provider-assigned unique ID for this managed resource.
- creation
Date String - The creation date of the SQL Elastic Pool.
- id String
- The provider-assigned unique ID for this managed resource.
- creation
Date string - The creation date of the SQL Elastic Pool.
- id string
- The provider-assigned unique ID for this managed resource.
- creation_
date str - The creation date of the SQL Elastic Pool.
- id str
- The provider-assigned unique ID for this managed resource.
- creation
Date String - The creation date of the SQL Elastic Pool.
- id String
- The provider-assigned unique ID for this managed resource.
Look up Existing ElasticPool Resource
Get an existing ElasticPool resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.
public static get(name: string, id: Input<ID>, state?: ElasticPoolState, opts?: CustomResourceOptions): ElasticPool
@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
creation_date: Optional[str] = None,
db_dtu_max: Optional[int] = None,
db_dtu_min: Optional[int] = None,
dtu: Optional[int] = None,
edition: Optional[str] = None,
location: Optional[str] = None,
name: Optional[str] = None,
pool_size: Optional[int] = None,
resource_group_name: Optional[str] = None,
server_name: Optional[str] = None,
tags: Optional[Mapping[str, str]] = None) -> ElasticPool
func GetElasticPool(ctx *Context, name string, id IDInput, state *ElasticPoolState, opts ...ResourceOption) (*ElasticPool, error)
public static ElasticPool Get(string name, Input<string> id, ElasticPoolState? state, CustomResourceOptions? opts = null)
public static ElasticPool get(String name, Output<String> id, ElasticPoolState state, CustomResourceOptions options)
Resource lookup is not supported in YAML
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- Creation
Date string - The creation date of the SQL Elastic Pool.
- Db
Dtu intMax - The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.
- Db
Dtu intMin - The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.
- Dtu int
- 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 string
- The edition of the elastic pool to be created. Valid values are
Basic
,Standard
, andPremium
. Refer to Azure SQL Database Service Tiers for details. Changing this forces a new resource to be created. - Location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- Name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- Pool
Size int - 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
anddtu
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 byedition
anddtu
. - Resource
Group stringName - 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.
- Server
Name string - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- Dictionary<string, string>
- A mapping of tags to assign to the resource.
- Creation
Date string - The creation date of the SQL Elastic Pool.
- Db
Dtu intMax - The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.
- Db
Dtu intMin - The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.
- Dtu int
- 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 string
- The edition of the elastic pool to be created. Valid values are
Basic
,Standard
, andPremium
. Refer to Azure SQL Database Service Tiers for details. Changing this forces a new resource to be created. - Location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- Name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- Pool
Size int - 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
anddtu
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 byedition
anddtu
. - Resource
Group stringName - 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.
- Server
Name string - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- map[string]string
- A mapping of tags to assign to the resource.
- creation
Date String - The creation date of the SQL Elastic Pool.
- db
Dtu IntegerMax - The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.
- db
Dtu IntegerMin - The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.
- dtu Integer
- 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 String
- The edition of the elastic pool to be created. Valid values are
Basic
,Standard
, andPremium
. Refer to Azure SQL Database Service Tiers for details. Changing this forces a new resource to be created. - location String
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- name String
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- pool
Size Integer - 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
anddtu
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 byedition
anddtu
. - resource
Group StringName - 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.
- server
Name String - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- Map<String,String>
- A mapping of tags to assign to the resource.
- creation
Date string - The creation date of the SQL Elastic Pool.
- db
Dtu numberMax - The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.
- db
Dtu numberMin - The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.
- dtu number
- 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 string
- The edition of the elastic pool to be created. Valid values are
Basic
,Standard
, andPremium
. Refer to Azure SQL Database Service Tiers for details. Changing this forces a new resource to be created. - location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- pool
Size number - 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
anddtu
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 byedition
anddtu
. - resource
Group stringName - 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.
- server
Name string - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- {[key: string]: string}
- A mapping of tags to assign to the resource.
- creation_
date str - The creation date of the SQL Elastic Pool.
- db_
dtu_ intmax - The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.
- db_
dtu_ intmin - The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.
- dtu int
- 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 str
- The edition of the elastic pool to be created. Valid values are
Basic
,Standard
, andPremium
. Refer to Azure SQL Database Service Tiers for details. Changing this forces a new resource to be created. - location str
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- name str
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- pool_
size int - 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
anddtu
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 byedition
anddtu
. - resource_
group_ strname - 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.
- server_
name str - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- Mapping[str, str]
- A mapping of tags to assign to the resource.
- creation
Date String - The creation date of the SQL Elastic Pool.
- db
Dtu NumberMax - The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.
- db
Dtu NumberMin - The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.
- dtu Number
- 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 String
- The edition of the elastic pool to be created. Valid values are
Basic
,Standard
, andPremium
. Refer to Azure SQL Database Service Tiers for details. Changing this forces a new resource to be created. - location String
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- name String
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- pool
Size Number - 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
anddtu
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 byedition
anddtu
. - resource
Group StringName - 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.
- server
Name String - The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
- Map<String>
- A mapping of tags to assign to the resource.
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
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- Azure Classic pulumi/pulumi-azure
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
azurerm
Terraform Provider.