We recommend using Azure Native.
azure.mssql.ElasticPool
Explore with Pulumi AI
Allows you to manage an Azure SQL Elastic Pool.
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 exampleServer = new azure.mssql.Server("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.mssql.ElasticPool("example", {
name: "test-epool",
resourceGroupName: example.name,
location: example.location,
serverName: exampleServer.name,
licenseType: "LicenseIncluded",
maxSizeGb: 756,
sku: {
name: "BasicPool",
tier: "Basic",
family: "Gen4",
capacity: 4,
},
perDatabaseSettings: {
minCapacity: 0.25,
maxCapacity: 4,
},
});
import pulumi
import pulumi_azure as azure
example = azure.core.ResourceGroup("example",
name="my-resource-group",
location="West Europe")
example_server = azure.mssql.Server("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.mssql.ElasticPool("example",
name="test-epool",
resource_group_name=example.name,
location=example.location,
server_name=example_server.name,
license_type="LicenseIncluded",
max_size_gb=756,
sku=azure.mssql.ElasticPoolSkuArgs(
name="BasicPool",
tier="Basic",
family="Gen4",
capacity=4,
),
per_database_settings=azure.mssql.ElasticPoolPerDatabaseSettingsArgs(
min_capacity=0.25,
max_capacity=4,
))
package main
import (
"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/core"
"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/mssql"
"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
}
exampleServer, err := mssql.NewServer(ctx, "example", &mssql.ServerArgs{
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 = mssql.NewElasticPool(ctx, "example", &mssql.ElasticPoolArgs{
Name: pulumi.String("test-epool"),
ResourceGroupName: example.Name,
Location: example.Location,
ServerName: exampleServer.Name,
LicenseType: pulumi.String("LicenseIncluded"),
MaxSizeGb: pulumi.Float64(756),
Sku: &mssql.ElasticPoolSkuArgs{
Name: pulumi.String("BasicPool"),
Tier: pulumi.String("Basic"),
Family: pulumi.String("Gen4"),
Capacity: pulumi.Int(4),
},
PerDatabaseSettings: &mssql.ElasticPoolPerDatabaseSettingsArgs{
MinCapacity: pulumi.Float64(0.25),
MaxCapacity: pulumi.Float64(4),
},
})
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 exampleServer = new Azure.MSSql.Server("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.MSSql.ElasticPool("example", new()
{
Name = "test-epool",
ResourceGroupName = example.Name,
Location = example.Location,
ServerName = exampleServer.Name,
LicenseType = "LicenseIncluded",
MaxSizeGb = 756,
Sku = new Azure.MSSql.Inputs.ElasticPoolSkuArgs
{
Name = "BasicPool",
Tier = "Basic",
Family = "Gen4",
Capacity = 4,
},
PerDatabaseSettings = new Azure.MSSql.Inputs.ElasticPoolPerDatabaseSettingsArgs
{
MinCapacity = 0.25,
MaxCapacity = 4,
},
});
});
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.mssql.Server;
import com.pulumi.azure.mssql.ServerArgs;
import com.pulumi.azure.mssql.ElasticPool;
import com.pulumi.azure.mssql.ElasticPoolArgs;
import com.pulumi.azure.mssql.inputs.ElasticPoolSkuArgs;
import com.pulumi.azure.mssql.inputs.ElasticPoolPerDatabaseSettingsArgs;
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 exampleServer = new Server("exampleServer", ServerArgs.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-epool")
.resourceGroupName(example.name())
.location(example.location())
.serverName(exampleServer.name())
.licenseType("LicenseIncluded")
.maxSizeGb(756)
.sku(ElasticPoolSkuArgs.builder()
.name("BasicPool")
.tier("Basic")
.family("Gen4")
.capacity(4)
.build())
.perDatabaseSettings(ElasticPoolPerDatabaseSettingsArgs.builder()
.minCapacity(0.25)
.maxCapacity(4)
.build())
.build());
}
}
resources:
example:
type: azure:core:ResourceGroup
properties:
name: my-resource-group
location: West Europe
exampleServer:
type: azure:mssql:Server
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:mssql:ElasticPool
name: example
properties:
name: test-epool
resourceGroupName: ${example.name}
location: ${example.location}
serverName: ${exampleServer.name}
licenseType: LicenseIncluded
maxSizeGb: 756
sku:
name: BasicPool
tier: Basic
family: Gen4
capacity: 4
perDatabaseSettings:
minCapacity: 0.25
maxCapacity: 4
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,
per_database_settings: Optional[ElasticPoolPerDatabaseSettingsArgs] = None,
sku: Optional[ElasticPoolSkuArgs] = None,
server_name: Optional[str] = None,
resource_group_name: Optional[str] = None,
maintenance_configuration_name: Optional[str] = None,
max_size_gb: Optional[float] = None,
name: Optional[str] = None,
max_size_bytes: Optional[int] = None,
enclave_type: Optional[str] = None,
location: Optional[str] = None,
license_type: Optional[str] = None,
tags: Optional[Mapping[str, str]] = None,
zone_redundant: Optional[bool] = 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:mssql: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 elasticPoolResource = new Azure.MSSql.ElasticPool("elasticPoolResource", new()
{
PerDatabaseSettings = new Azure.MSSql.Inputs.ElasticPoolPerDatabaseSettingsArgs
{
MaxCapacity = 0,
MinCapacity = 0,
},
Sku = new Azure.MSSql.Inputs.ElasticPoolSkuArgs
{
Capacity = 0,
Name = "string",
Tier = "string",
Family = "string",
},
ServerName = "string",
ResourceGroupName = "string",
MaintenanceConfigurationName = "string",
MaxSizeGb = 0,
Name = "string",
MaxSizeBytes = 0,
EnclaveType = "string",
Location = "string",
LicenseType = "string",
Tags =
{
{ "string", "string" },
},
ZoneRedundant = false,
});
example, err := mssql.NewElasticPool(ctx, "elasticPoolResource", &mssql.ElasticPoolArgs{
PerDatabaseSettings: &mssql.ElasticPoolPerDatabaseSettingsArgs{
MaxCapacity: pulumi.Float64(0),
MinCapacity: pulumi.Float64(0),
},
Sku: &mssql.ElasticPoolSkuArgs{
Capacity: pulumi.Int(0),
Name: pulumi.String("string"),
Tier: pulumi.String("string"),
Family: pulumi.String("string"),
},
ServerName: pulumi.String("string"),
ResourceGroupName: pulumi.String("string"),
MaintenanceConfigurationName: pulumi.String("string"),
MaxSizeGb: pulumi.Float64(0),
Name: pulumi.String("string"),
MaxSizeBytes: pulumi.Int(0),
EnclaveType: pulumi.String("string"),
Location: pulumi.String("string"),
LicenseType: pulumi.String("string"),
Tags: pulumi.StringMap{
"string": pulumi.String("string"),
},
ZoneRedundant: pulumi.Bool(false),
})
var elasticPoolResource = new ElasticPool("elasticPoolResource", ElasticPoolArgs.builder()
.perDatabaseSettings(ElasticPoolPerDatabaseSettingsArgs.builder()
.maxCapacity(0)
.minCapacity(0)
.build())
.sku(ElasticPoolSkuArgs.builder()
.capacity(0)
.name("string")
.tier("string")
.family("string")
.build())
.serverName("string")
.resourceGroupName("string")
.maintenanceConfigurationName("string")
.maxSizeGb(0)
.name("string")
.maxSizeBytes(0)
.enclaveType("string")
.location("string")
.licenseType("string")
.tags(Map.of("string", "string"))
.zoneRedundant(false)
.build());
elastic_pool_resource = azure.mssql.ElasticPool("elasticPoolResource",
per_database_settings=azure.mssql.ElasticPoolPerDatabaseSettingsArgs(
max_capacity=0,
min_capacity=0,
),
sku=azure.mssql.ElasticPoolSkuArgs(
capacity=0,
name="string",
tier="string",
family="string",
),
server_name="string",
resource_group_name="string",
maintenance_configuration_name="string",
max_size_gb=0,
name="string",
max_size_bytes=0,
enclave_type="string",
location="string",
license_type="string",
tags={
"string": "string",
},
zone_redundant=False)
const elasticPoolResource = new azure.mssql.ElasticPool("elasticPoolResource", {
perDatabaseSettings: {
maxCapacity: 0,
minCapacity: 0,
},
sku: {
capacity: 0,
name: "string",
tier: "string",
family: "string",
},
serverName: "string",
resourceGroupName: "string",
maintenanceConfigurationName: "string",
maxSizeGb: 0,
name: "string",
maxSizeBytes: 0,
enclaveType: "string",
location: "string",
licenseType: "string",
tags: {
string: "string",
},
zoneRedundant: false,
});
type: azure:mssql:ElasticPool
properties:
enclaveType: string
licenseType: string
location: string
maintenanceConfigurationName: string
maxSizeBytes: 0
maxSizeGb: 0
name: string
perDatabaseSettings:
maxCapacity: 0
minCapacity: 0
resourceGroupName: string
serverName: string
sku:
capacity: 0
family: string
name: string
tier: string
tags:
string: string
zoneRedundant: false
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:
- Per
Database ElasticSettings Pool Per Database Settings - A
per_database_settingsblock as defined below. - 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.
- Sku
Elastic
Pool Sku - A
skublock as defined below. - Enclave
Type string Specifies the type of enclave to be used by the elastic pool. When
enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefaultorVBS) removing theenclave_typefield from the configuration file will force the creation of a new resource.-> Possible values areDefaultorVBS.NOTE: All databases that are added to the elastic pool must have the same
enclave_typeas the elastic pool.NOTE:
enclave_typeis not supported for DC-series SKUs.NOTE: The default value for
enclave_typefield is unset notDefault.- License
Type string - Specifies the license type applied to this database. Possible values are
LicenseIncludedandBasePrice. - Location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- Maintenance
Configuration stringName - The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include
SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default. - Max
Size intBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb.NOTE: One of either
max_size_gbormax_size_bytesmust be specified.- Max
Size doubleGb - The max data size of the elastic pool in gigabytes. Conflicts with
max_size_bytes. - Name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- Dictionary<string, string>
- A mapping of tags to assign to the resource.
- Zone
Redundant bool - Whether or not this elastic pool is zone redundant.
tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- Per
Database ElasticSettings Pool Per Database Settings Args - A
per_database_settingsblock as defined below. - 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.
- Sku
Elastic
Pool Sku Args - A
skublock as defined below. - Enclave
Type string Specifies the type of enclave to be used by the elastic pool. When
enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefaultorVBS) removing theenclave_typefield from the configuration file will force the creation of a new resource.-> Possible values areDefaultorVBS.NOTE: All databases that are added to the elastic pool must have the same
enclave_typeas the elastic pool.NOTE:
enclave_typeis not supported for DC-series SKUs.NOTE: The default value for
enclave_typefield is unset notDefault.- License
Type string - Specifies the license type applied to this database. Possible values are
LicenseIncludedandBasePrice. - Location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- Maintenance
Configuration stringName - The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include
SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default. - Max
Size intBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb.NOTE: One of either
max_size_gbormax_size_bytesmust be specified.- Max
Size float64Gb - The max data size of the elastic pool in gigabytes. Conflicts with
max_size_bytes. - Name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- map[string]string
- A mapping of tags to assign to the resource.
- Zone
Redundant bool - Whether or not this elastic pool is zone redundant.
tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- per
Database ElasticSettings Pool Per Database Settings - A
per_database_settingsblock as defined below. - 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.
- sku
Elastic
Pool Sku - A
skublock as defined below. - enclave
Type String Specifies the type of enclave to be used by the elastic pool. When
enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefaultorVBS) removing theenclave_typefield from the configuration file will force the creation of a new resource.-> Possible values areDefaultorVBS.NOTE: All databases that are added to the elastic pool must have the same
enclave_typeas the elastic pool.NOTE:
enclave_typeis not supported for DC-series SKUs.NOTE: The default value for
enclave_typefield is unset notDefault.- license
Type String - Specifies the license type applied to this database. Possible values are
LicenseIncludedandBasePrice. - location String
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration StringName - The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include
SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default. - max
Size IntegerBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb.NOTE: One of either
max_size_gbormax_size_bytesmust be specified.- max
Size DoubleGb - The max data size of the elastic pool in gigabytes. Conflicts with
max_size_bytes. - name String
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- Map<String,String>
- A mapping of tags to assign to the resource.
- zone
Redundant Boolean - Whether or not this elastic pool is zone redundant.
tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- per
Database ElasticSettings Pool Per Database Settings - A
per_database_settingsblock as defined below. - 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.
- sku
Elastic
Pool Sku - A
skublock as defined below. - enclave
Type string Specifies the type of enclave to be used by the elastic pool. When
enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefaultorVBS) removing theenclave_typefield from the configuration file will force the creation of a new resource.-> Possible values areDefaultorVBS.NOTE: All databases that are added to the elastic pool must have the same
enclave_typeas the elastic pool.NOTE:
enclave_typeis not supported for DC-series SKUs.NOTE: The default value for
enclave_typefield is unset notDefault.- license
Type string - Specifies the license type applied to this database. Possible values are
LicenseIncludedandBasePrice. - location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration stringName - The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include
SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default. - max
Size numberBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb.NOTE: One of either
max_size_gbormax_size_bytesmust be specified.- max
Size numberGb - The max data size of the elastic pool in gigabytes. Conflicts with
max_size_bytes. - name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- {[key: string]: string}
- A mapping of tags to assign to the resource.
- zone
Redundant boolean - Whether or not this elastic pool is zone redundant.
tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- per_
database_ Elasticsettings Pool Per Database Settings Args - A
per_database_settingsblock as defined below. - 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.
- sku
Elastic
Pool Sku Args - A
skublock as defined below. - enclave_
type str Specifies the type of enclave to be used by the elastic pool. When
enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefaultorVBS) removing theenclave_typefield from the configuration file will force the creation of a new resource.-> Possible values areDefaultorVBS.NOTE: All databases that are added to the elastic pool must have the same
enclave_typeas the elastic pool.NOTE:
enclave_typeis not supported for DC-series SKUs.NOTE: The default value for
enclave_typefield is unset notDefault.- license_
type str - Specifies the license type applied to this database. Possible values are
LicenseIncludedandBasePrice. - location str
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance_
configuration_ strname - The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include
SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default. - max_
size_ intbytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb.NOTE: One of either
max_size_gbormax_size_bytesmust be specified.- max_
size_ floatgb - The max data size of the elastic pool in gigabytes. Conflicts with
max_size_bytes. - name str
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- Mapping[str, str]
- A mapping of tags to assign to the resource.
- zone_
redundant bool - Whether or not this elastic pool is zone redundant.
tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- per
Database Property MapSettings - A
per_database_settingsblock as defined below. - 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.
- sku Property Map
- A
skublock as defined below. - enclave
Type String Specifies the type of enclave to be used by the elastic pool. When
enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefaultorVBS) removing theenclave_typefield from the configuration file will force the creation of a new resource.-> Possible values areDefaultorVBS.NOTE: All databases that are added to the elastic pool must have the same
enclave_typeas the elastic pool.NOTE:
enclave_typeis not supported for DC-series SKUs.NOTE: The default value for
enclave_typefield is unset notDefault.- license
Type String - Specifies the license type applied to this database. Possible values are
LicenseIncludedandBasePrice. - location String
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration StringName - The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include
SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default. - max
Size NumberBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb.NOTE: One of either
max_size_gbormax_size_bytesmust be specified.- max
Size NumberGb - The max data size of the elastic pool in gigabytes. Conflicts with
max_size_bytes. - name String
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- Map<String>
- A mapping of tags to assign to the resource.
- zone
Redundant Boolean - Whether or not this elastic pool is zone redundant.
tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
Outputs
All input properties are implicitly available as output properties. Additionally, the ElasticPool resource produces the following output properties:
- Id string
- The provider-assigned unique ID for this managed resource.
- Id string
- The provider-assigned unique ID for this managed resource.
- id String
- The provider-assigned unique ID for this managed resource.
- id string
- The provider-assigned unique ID for this managed resource.
- id str
- The provider-assigned unique ID for this managed resource.
- 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,
enclave_type: Optional[str] = None,
license_type: Optional[str] = None,
location: Optional[str] = None,
maintenance_configuration_name: Optional[str] = None,
max_size_bytes: Optional[int] = None,
max_size_gb: Optional[float] = None,
name: Optional[str] = None,
per_database_settings: Optional[ElasticPoolPerDatabaseSettingsArgs] = None,
resource_group_name: Optional[str] = None,
server_name: Optional[str] = None,
sku: Optional[ElasticPoolSkuArgs] = None,
tags: Optional[Mapping[str, str]] = None,
zone_redundant: Optional[bool] = None) -> ElasticPoolfunc 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.
- Enclave
Type string Specifies the type of enclave to be used by the elastic pool. When
enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefaultorVBS) removing theenclave_typefield from the configuration file will force the creation of a new resource.-> Possible values areDefaultorVBS.NOTE: All databases that are added to the elastic pool must have the same
enclave_typeas the elastic pool.NOTE:
enclave_typeis not supported for DC-series SKUs.NOTE: The default value for
enclave_typefield is unset notDefault.- License
Type string - Specifies the license type applied to this database. Possible values are
LicenseIncludedandBasePrice. - Location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- Maintenance
Configuration stringName - The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include
SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default. - Max
Size intBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb.NOTE: One of either
max_size_gbormax_size_bytesmust be specified.- Max
Size doubleGb - The max data size of the elastic pool in gigabytes. Conflicts with
max_size_bytes. - Name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- Per
Database ElasticSettings Pool Per Database Settings - A
per_database_settingsblock as defined below. - 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.
- Sku
Elastic
Pool Sku - A
skublock as defined below. - Dictionary<string, string>
- A mapping of tags to assign to the resource.
- Zone
Redundant bool - Whether or not this elastic pool is zone redundant.
tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- Enclave
Type string Specifies the type of enclave to be used by the elastic pool. When
enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefaultorVBS) removing theenclave_typefield from the configuration file will force the creation of a new resource.-> Possible values areDefaultorVBS.NOTE: All databases that are added to the elastic pool must have the same
enclave_typeas the elastic pool.NOTE:
enclave_typeis not supported for DC-series SKUs.NOTE: The default value for
enclave_typefield is unset notDefault.- License
Type string - Specifies the license type applied to this database. Possible values are
LicenseIncludedandBasePrice. - Location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- Maintenance
Configuration stringName - The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include
SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default. - Max
Size intBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb.NOTE: One of either
max_size_gbormax_size_bytesmust be specified.- Max
Size float64Gb - The max data size of the elastic pool in gigabytes. Conflicts with
max_size_bytes. - Name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- Per
Database ElasticSettings Pool Per Database Settings Args - A
per_database_settingsblock as defined below. - 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.
- Sku
Elastic
Pool Sku Args - A
skublock as defined below. - map[string]string
- A mapping of tags to assign to the resource.
- Zone
Redundant bool - Whether or not this elastic pool is zone redundant.
tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- enclave
Type String Specifies the type of enclave to be used by the elastic pool. When
enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefaultorVBS) removing theenclave_typefield from the configuration file will force the creation of a new resource.-> Possible values areDefaultorVBS.NOTE: All databases that are added to the elastic pool must have the same
enclave_typeas the elastic pool.NOTE:
enclave_typeis not supported for DC-series SKUs.NOTE: The default value for
enclave_typefield is unset notDefault.- license
Type String - Specifies the license type applied to this database. Possible values are
LicenseIncludedandBasePrice. - location String
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration StringName - The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include
SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default. - max
Size IntegerBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb.NOTE: One of either
max_size_gbormax_size_bytesmust be specified.- max
Size DoubleGb - The max data size of the elastic pool in gigabytes. Conflicts with
max_size_bytes. - name String
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- per
Database ElasticSettings Pool Per Database Settings - A
per_database_settingsblock as defined below. - 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.
- sku
Elastic
Pool Sku - A
skublock as defined below. - Map<String,String>
- A mapping of tags to assign to the resource.
- zone
Redundant Boolean - Whether or not this elastic pool is zone redundant.
tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- enclave
Type string Specifies the type of enclave to be used by the elastic pool. When
enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefaultorVBS) removing theenclave_typefield from the configuration file will force the creation of a new resource.-> Possible values areDefaultorVBS.NOTE: All databases that are added to the elastic pool must have the same
enclave_typeas the elastic pool.NOTE:
enclave_typeis not supported for DC-series SKUs.NOTE: The default value for
enclave_typefield is unset notDefault.- license
Type string - Specifies the license type applied to this database. Possible values are
LicenseIncludedandBasePrice. - location string
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration stringName - The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include
SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default. - max
Size numberBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb.NOTE: One of either
max_size_gbormax_size_bytesmust be specified.- max
Size numberGb - The max data size of the elastic pool in gigabytes. Conflicts with
max_size_bytes. - name string
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- per
Database ElasticSettings Pool Per Database Settings - A
per_database_settingsblock as defined below. - 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.
- sku
Elastic
Pool Sku - A
skublock as defined below. - {[key: string]: string}
- A mapping of tags to assign to the resource.
- zone
Redundant boolean - Whether or not this elastic pool is zone redundant.
tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- enclave_
type str Specifies the type of enclave to be used by the elastic pool. When
enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefaultorVBS) removing theenclave_typefield from the configuration file will force the creation of a new resource.-> Possible values areDefaultorVBS.NOTE: All databases that are added to the elastic pool must have the same
enclave_typeas the elastic pool.NOTE:
enclave_typeis not supported for DC-series SKUs.NOTE: The default value for
enclave_typefield is unset notDefault.- license_
type str - Specifies the license type applied to this database. Possible values are
LicenseIncludedandBasePrice. - location str
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance_
configuration_ strname - The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include
SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default. - max_
size_ intbytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb.NOTE: One of either
max_size_gbormax_size_bytesmust be specified.- max_
size_ floatgb - The max data size of the elastic pool in gigabytes. Conflicts with
max_size_bytes. - name str
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- per_
database_ Elasticsettings Pool Per Database Settings Args - A
per_database_settingsblock as defined below. - 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.
- sku
Elastic
Pool Sku Args - A
skublock as defined below. - Mapping[str, str]
- A mapping of tags to assign to the resource.
- zone_
redundant bool - Whether or not this elastic pool is zone redundant.
tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
- enclave
Type String Specifies the type of enclave to be used by the elastic pool. When
enclave_typeis not specified (e.g., the default) enclaves are not enabled on the elastic pool. <!-- TODO: Uncomment in 4.0: Once enabled (e.g., by specifyingDefaultorVBS) removing theenclave_typefield from the configuration file will force the creation of a new resource.-> Possible values areDefaultorVBS.NOTE: All databases that are added to the elastic pool must have the same
enclave_typeas the elastic pool.NOTE:
enclave_typeis not supported for DC-series SKUs.NOTE: The default value for
enclave_typefield is unset notDefault.- license
Type String - Specifies the license type applied to this database. Possible values are
LicenseIncludedandBasePrice. - location String
- Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration StringName - The name of the Public Maintenance Configuration window to apply to the elastic pool. Valid values include
SQL_Default,SQL_EastUS_DB_1,SQL_EastUS2_DB_1,SQL_SoutheastAsia_DB_1,SQL_AustraliaEast_DB_1,SQL_NorthEurope_DB_1,SQL_SouthCentralUS_DB_1,SQL_WestUS2_DB_1,SQL_UKSouth_DB_1,SQL_WestEurope_DB_1,SQL_EastUS_DB_2,SQL_EastUS2_DB_2,SQL_WestUS2_DB_2,SQL_SoutheastAsia_DB_2,SQL_AustraliaEast_DB_2,SQL_NorthEurope_DB_2,SQL_SouthCentralUS_DB_2,SQL_UKSouth_DB_2,SQL_WestEurope_DB_2,SQL_AustraliaSoutheast_DB_1,SQL_BrazilSouth_DB_1,SQL_CanadaCentral_DB_1,SQL_CanadaEast_DB_1,SQL_CentralUS_DB_1,SQL_EastAsia_DB_1,SQL_FranceCentral_DB_1,SQL_GermanyWestCentral_DB_1,SQL_CentralIndia_DB_1,SQL_SouthIndia_DB_1,SQL_JapanEast_DB_1,SQL_JapanWest_DB_1,SQL_NorthCentralUS_DB_1,SQL_UKWest_DB_1,SQL_WestUS_DB_1,SQL_AustraliaSoutheast_DB_2,SQL_BrazilSouth_DB_2,SQL_CanadaCentral_DB_2,SQL_CanadaEast_DB_2,SQL_CentralUS_DB_2,SQL_EastAsia_DB_2,SQL_FranceCentral_DB_2,SQL_GermanyWestCentral_DB_2,SQL_CentralIndia_DB_2,SQL_SouthIndia_DB_2,SQL_JapanEast_DB_2,SQL_JapanWest_DB_2,SQL_NorthCentralUS_DB_2,SQL_UKWest_DB_2,SQL_WestUS_DB_2,SQL_WestCentralUS_DB_1,SQL_FranceSouth_DB_1,SQL_WestCentralUS_DB_2,SQL_FranceSouth_DB_2,SQL_SwitzerlandNorth_DB_1,SQL_SwitzerlandNorth_DB_2,SQL_BrazilSoutheast_DB_1,SQL_UAENorth_DB_1,SQL_BrazilSoutheast_DB_2,SQL_UAENorth_DB_2,SQL_SouthAfricaNorth_DB_1,SQL_SouthAfricaNorth_DB_2,SQL_WestUS3_DB_1,SQL_WestUS3_DB_2. Defaults toSQL_Default. - max
Size NumberBytes The max data size of the elastic pool in bytes. Conflicts with
max_size_gb.NOTE: One of either
max_size_gbormax_size_bytesmust be specified.- max
Size NumberGb - The max data size of the elastic pool in gigabytes. Conflicts with
max_size_bytes. - name String
- The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
- per
Database Property MapSettings - A
per_database_settingsblock as defined below. - 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.
- sku Property Map
- A
skublock as defined below. - Map<String>
- A mapping of tags to assign to the resource.
- zone
Redundant Boolean - Whether or not this elastic pool is zone redundant.
tierneeds to bePremiumforDTUbased orBusinessCriticalforvCorebasedsku.
Supporting Types
ElasticPoolPerDatabaseSettings, ElasticPoolPerDatabaseSettingsArgs
- Max
Capacity double - The maximum capacity any one database can consume.
- Min
Capacity double - The minimum capacity all databases are guaranteed.
- Max
Capacity float64 - The maximum capacity any one database can consume.
- Min
Capacity float64 - The minimum capacity all databases are guaranteed.
- max
Capacity Double - The maximum capacity any one database can consume.
- min
Capacity Double - The minimum capacity all databases are guaranteed.
- max
Capacity number - The maximum capacity any one database can consume.
- min
Capacity number - The minimum capacity all databases are guaranteed.
- max_
capacity float - The maximum capacity any one database can consume.
- min_
capacity float - The minimum capacity all databases are guaranteed.
- max
Capacity Number - The maximum capacity any one database can consume.
- min
Capacity Number - The minimum capacity all databases are guaranteed.
ElasticPoolSku, ElasticPoolSkuArgs
- Capacity int
- The scale up/out capacity, representing server's compute units. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- Name string
- Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either
vCorebased orDTUbased. PossibleDTUbased values areBasicPool,StandardPool,PremiumPoolwhile possiblevCorebased values areGP_Gen4,GP_Gen5,GP_Fsv2,GP_DC,BC_Gen4,BC_Gen5,BC_DC,HS_PRMS, orHS_Gen5. - Tier string
- The tier of the particular SKU. Possible values are
GeneralPurpose,BusinessCritical,Basic,Standard,Premium, orHyperScale. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based. - Family string
- The
familyof hardwareGen4,Gen5,Fsv2orDC.
- Capacity int
- The scale up/out capacity, representing server's compute units. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- Name string
- Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either
vCorebased orDTUbased. PossibleDTUbased values areBasicPool,StandardPool,PremiumPoolwhile possiblevCorebased values areGP_Gen4,GP_Gen5,GP_Fsv2,GP_DC,BC_Gen4,BC_Gen5,BC_DC,HS_PRMS, orHS_Gen5. - Tier string
- The tier of the particular SKU. Possible values are
GeneralPurpose,BusinessCritical,Basic,Standard,Premium, orHyperScale. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based. - Family string
- The
familyof hardwareGen4,Gen5,Fsv2orDC.
- capacity Integer
- The scale up/out capacity, representing server's compute units. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- name String
- Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either
vCorebased orDTUbased. PossibleDTUbased values areBasicPool,StandardPool,PremiumPoolwhile possiblevCorebased values areGP_Gen4,GP_Gen5,GP_Fsv2,GP_DC,BC_Gen4,BC_Gen5,BC_DC,HS_PRMS, orHS_Gen5. - tier String
- The tier of the particular SKU. Possible values are
GeneralPurpose,BusinessCritical,Basic,Standard,Premium, orHyperScale. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based. - family String
- The
familyof hardwareGen4,Gen5,Fsv2orDC.
- capacity number
- The scale up/out capacity, representing server's compute units. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- name string
- Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either
vCorebased orDTUbased. PossibleDTUbased values areBasicPool,StandardPool,PremiumPoolwhile possiblevCorebased values areGP_Gen4,GP_Gen5,GP_Fsv2,GP_DC,BC_Gen4,BC_Gen5,BC_DC,HS_PRMS, orHS_Gen5. - tier string
- The tier of the particular SKU. Possible values are
GeneralPurpose,BusinessCritical,Basic,Standard,Premium, orHyperScale. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based. - family string
- The
familyof hardwareGen4,Gen5,Fsv2orDC.
- capacity int
- The scale up/out capacity, representing server's compute units. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- name str
- Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either
vCorebased orDTUbased. PossibleDTUbased values areBasicPool,StandardPool,PremiumPoolwhile possiblevCorebased values areGP_Gen4,GP_Gen5,GP_Fsv2,GP_DC,BC_Gen4,BC_Gen5,BC_DC,HS_PRMS, orHS_Gen5. - tier str
- The tier of the particular SKU. Possible values are
GeneralPurpose,BusinessCritical,Basic,Standard,Premium, orHyperScale. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based. - family str
- The
familyof hardwareGen4,Gen5,Fsv2orDC.
- capacity Number
- The scale up/out capacity, representing server's compute units. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based.
- name String
- Specifies the SKU Name for this Elasticpool. The name of the SKU, will be either
vCorebased orDTUbased. PossibleDTUbased values areBasicPool,StandardPool,PremiumPoolwhile possiblevCorebased values areGP_Gen4,GP_Gen5,GP_Fsv2,GP_DC,BC_Gen4,BC_Gen5,BC_DC,HS_PRMS, orHS_Gen5. - tier String
- The tier of the particular SKU. Possible values are
GeneralPurpose,BusinessCritical,Basic,Standard,Premium, orHyperScale. For more information see the documentation for your Elasticpool configuration: vCore-based or DTU-based. - family String
- The
familyof hardwareGen4,Gen5,Fsv2orDC.
Import
SQL Elastic Pool can be imported using the resource id, e.g.
$ pulumi import azure:mssql/elasticPool:ElasticPool example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/myresourcegroup/providers/Microsoft.Sql/servers/myserver/elasticPools/myelasticpoolname
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
azurermTerraform Provider.