Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

azurerm_mssql_elasticpool: unable to specify "Max Data Size" of pool #2338

Closed
raphaelquati opened this issue Nov 16, 2018 · 1 comment
Closed
Labels
enhancement service/mssql Microsoft SQL Server

Comments

@raphaelquati
Copy link
Contributor

Impossible to specify a max data size to pool.
And I cannot use the "elastic_pool_properties" structure.

Terraform script

resource "azurerm_mssql_elasticpool" "test" {
    name="test"
    resource_group_name = "${azurerm_resource_group.test.name}"
    location            = "${azurerm_resource_group.test.location}"
    server_name         = "${azurerm_sql_server.test.name}"

    sku {
        name     = "GP_Gen4"
        capacity = 1
        tier     = "GeneralPurpose"
        family   = "Gen4"
    }

    per_database_settings {
        min_capacity = 0
        max_capacity = 1
    }
}

Terraform state after creation:

> terraform state show azurerm_mssql_elasticpool.test
id                                       = /subscriptions/xxxxxxxxxxxxxxxxxxxx
/xxxxx/providers/Microsoft.Sql/servers/yyyyyyyyy/elasticPools/zzzzzzzzzzzzzz
elastic_pool_properties.#                = 1
elastic_pool_properties.0.creation_date  = 2018-11-16T15:25:41.467Z
elastic_pool_properties.0.license_type   = LicenseIncluded
elastic_pool_properties.0.max_size_bytes = 34359738368
elastic_pool_properties.0.state          = Ready
elastic_pool_properties.0.zone_redundant = false
location                                 = eastus
name                                     = zzzzzzzzzzzzzzzzzzz
per_database_settings.#                  = 1
per_database_settings.0.max_capacity     = 1
per_database_settings.0.min_capacity     = 0
resource_group_name                      = xxxxxxxxxxxxxxx
server_name                              = sssssssssssss
sku.#                                    = 1
sku.0.capacity                           = 1
sku.0.family                             = Gen4
sku.0.name                               = GP_Gen4
sku.0.tier                               = GeneralPurpose
tags.%                                   = 0

image

@ghost
Copy link

ghost commented May 16, 2021

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.

If you feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. If you feel I made an error 🤖 🙉 , please reach out to my human friends 👉 [email protected]. Thanks!

@ghost ghost locked as resolved and limited conversation to collaborators May 16, 2021
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
enhancement service/mssql Microsoft SQL Server
Projects
None yet
Development

No branches or pull requests

2 participants