CODEWITHSUNDEEP
azureazure-sql-databaseazure-policy
Developist
Developist

Reputation: 23

Azure Policies to limit the scaling of database

When a new SQL database is created on Azure, it sets "Compute+Storage" option to "2 vCore + 32GB data max size" as a default configuration but I don't want to use vCore and I can change it. But the question is that if it is possible to limit the subscription with a policy to not let any user be able to create a database with undesired size. Is there any way to limit the scaling of the database?

Upvotes: 2

Views: 529

Answers (1)

Leon Yue
Leon Yue

Reputation: 16411

vCore model General Purpose is the default price tier of Azure SQL database. We can't change the default configuration but we can manually change it to DTU model manually after it created like you said.

About your question "Is it possible to limit the subscription with a policy to not let any user be able to create a database with undesired size?", the policy is that only the server admin account can change and create database.

Azure database support auto scale up according your data increasing and database price tier. It's the feature and we can't disable it. When you design your database, you need think about the max size of the database. When the limit arrived, you need to choose the higher price tier. In one word, there isn't a way to limit the scaling of the database.

HTH.

Upvotes: 1

Related Questions