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.

Sign up for GitHub

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

Jump to bottom

Move SQL Server to serverless #293

Open
tanya-borisova opened this issue Apr 27, 2023 · 1 comment
Open

Move SQL Server to serverless #293

tanya-borisova opened this issue Apr 27, 2023 · 1 comment
Labels
Data Transformation Data Transformation Epic User Story User Story level Item

Comments

@tanya-borisova
Copy link
Member

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
@tanya-borisova tanya-borisova added User Story User Story level Item Data Transformation Data Transformation Epic labels Apr 27, 2023
@Yashar8991
Copy link

what is SQL Server version?.Can you give me more about information?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Data Transformation Data Transformation Epic User Story User Story level Item
Projects
FlowEHR
Status: No status
Milestone
No milestone
Development

No branches or pull requests
2 participants
@tanya-borisova @Yashar8991