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
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Azure = Pulumi.Azure;
return await Deployment.RunAsync(() =>
{
var exampleResourceGroup = new Azure.Core.ResourceGroup("exampleResourceGroup", new()
{
Location = "West Europe",
});
var exampleSqlServer = new Azure.Sql.SqlServer("exampleSqlServer", new()
{
ResourceGroupName = exampleResourceGroup.Name,
Location = exampleResourceGroup.Location,
Version = "12.0",
AdministratorLogin = "4dm1n157r470r",
AdministratorLoginPassword = "4-v3ry-53cr37-p455w0rd",
});
var exampleElasticPool = new Azure.Sql.ElasticPool("exampleElasticPool", new()
{
ResourceGroupName = exampleResourceGroup.Name,
Location = exampleResourceGroup.Location,
ServerName = exampleSqlServer.Name,
Edition = "Basic",
Dtu = 50,
DbDtuMin = 0,
DbDtuMax = 5,
PoolSize = 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 {
exampleResourceGroup, err := core.NewResourceGroup(ctx, "exampleResourceGroup", &core.ResourceGroupArgs{
Location: pulumi.String("West Europe"),
})
if err != nil {
return err
}
exampleSqlServer, err := sql.NewSqlServer(ctx, "exampleSqlServer", &sql.SqlServerArgs{
ResourceGroupName: exampleResourceGroup.Name,
Location: exampleResourceGroup.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, "exampleElasticPool", &sql.ElasticPoolArgs{
ResourceGroupName: exampleResourceGroup.Name,
Location: exampleResourceGroup.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
})
}
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 pulumi
import pulumi_azure as azure
example_resource_group = azure.core.ResourceGroup("exampleResourceGroup", location="West Europe")
example_sql_server = azure.sql.SqlServer("exampleSqlServer",
resource_group_name=example_resource_group.name,
location=example_resource_group.location,
version="12.0",
administrator_login="4dm1n157r470r",
administrator_login_password="4-v3ry-53cr37-p455w0rd")
example_elastic_pool = azure.sql.ElasticPool("exampleElasticPool",
resource_group_name=example_resource_group.name,
location=example_resource_group.location,
server_name=example_sql_server.name,
edition="Basic",
dtu=50,
db_dtu_min=0,
db_dtu_max=5,
pool_size=5000)
import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";
const exampleResourceGroup = new azure.core.ResourceGroup("exampleResourceGroup", {location: "West Europe"});
const exampleSqlServer = new azure.sql.SqlServer("exampleSqlServer", {
resourceGroupName: exampleResourceGroup.name,
location: exampleResourceGroup.location,
version: "12.0",
administratorLogin: "4dm1n157r470r",
administratorLoginPassword: "4-v3ry-53cr37-p455w0rd",
});
const exampleElasticPool = new azure.sql.ElasticPool("exampleElasticPool", {
resourceGroupName: exampleResourceGroup.name,
location: exampleResourceGroup.location,
serverName: exampleSqlServer.name,
edition: "Basic",
dtu: 50,
dbDtuMin: 0,
dbDtuMax: 5,
poolSize: 5000,
});
resources:
exampleResourceGroup:
type: azure:core:ResourceGroup
properties:
location: West Europe
exampleSqlServer:
type: azure:sql:SqlServer
properties:
# NOTE: needs to be globally unique
resourceGroupName: ${exampleResourceGroup.name}
location: ${exampleResourceGroup.location}
version: '12.0'
administratorLogin: 4dm1n157r470r
administratorLoginPassword: 4-v3ry-53cr37-p455w0rd
exampleElasticPool:
type: azure:sql:ElasticPool
properties:
resourceGroupName: ${exampleResourceGroup.name}
location: ${exampleResourceGroup.location}
serverName: ${exampleSqlServer.name}
edition: Basic
dtu: 50
dbDtuMin: 0
dbDtuMax: 5
poolSize: 5000
Create ElasticPool Resource
new ElasticPool(name: string, args: ElasticPoolArgs, opts?: CustomResourceOptions);
@overload
def ElasticPool(resource_name: str,
opts: Optional[ResourceOptions] = 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)
@overload
def ElasticPool(resource_name: str,
args: ElasticPoolArgs,
opts: Optional[ResourceOptions] = 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.
- 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.
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
Package Details
- Repository
- Azure Classic pulumi/pulumi-azure
- License
- Apache-2.0
- Notes
This Pulumi package is based on the
azurerm
Terraform Provider.