How can we improve Azure SQL Database?

Auto Scaling for Azure SQL

Ability to create rules which enable automatically scaling up or down the DTUs on an Azure SQL Database based on usage.

129 votes
Vote
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...
  • Peter Bannister commented  ·   ·  Flag as inappropriate

    A work around is to use a scheduler job to invoke a worker role method to call an SQL for alter DB.
    This looses connection when the final scale is done, but we use this for scaling up/down for daily workload, but before people come in / leave.
    Works very well for us

Feedback and Knowledge Base