Skip to content

Move SQL Server to serverless #293

@tanya-borisova

Description

@tanya-borisova

Description

We would like to move SQL Server to serverless so that it would scale down to 0 when unused but would add resources when queries are performed.

We suggest the following configuration:

min_capacity: 2
sku_name: GP_S_Gen5_8
auto_pause_delay_in_minutes: 60

Note that this doesn't seem to work when simply applied from the terraform configuration to convert from provisioned to serverless: as the license type is already set, we're getting a message "serverless databases do not support license type" even when removing the license type. See an issue hashicorp/terraform-provider-azurerm#15455

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    Status

    No status

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions