Autoscaling Azure SQL Hyperscale

Vijay Kumar 2,036 Reputation points
2022-10-13T23:37:53.35+00:00

Hi,

We are planning to implement Autoscaling (to reduce cost during off-peak hours) for all our Azure SQL Hyperscale databases.

Please suggest to us, how to implement this.

Azure SQL Database
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Alberto Morillo 34,461 Reputation points MVP
    2022-10-14T02:31:22.247+00:00

    You can use Azure Automation to schedule scale down during off-peak hours and scale up just before business hours start. The scale up/down process is faster with Azure Hyperscale than with other PaaS options like DTU model.

    0 comments No comments

  2. Oury Ba-MSFT 20,346 Reputation points Microsoft Employee
    2022-10-14T16:31:01.893+00:00

    Hi @Vijay Kumar
    Thank you for posting your question on Microsoft Q&A and for using Azure services.
    As per my understanding you are trying to auto scale your Azure SQL Hyperscale database so you can reduce cost between OFF peak hours.
    In addition to what @Alberto Morillo has mentioned above you can create a simple algorithm that will tell you when scale-up is needed or when scale down is recommended first then you can implement a monitoring job that will get such data and kick off the scaling operation.
    Every 15 seconds the Azure Function will wake up and will get the current performance data from an Azure SQL Hyperscale database, along with the 1-minute moving average.

    Here’s an example of such Azure Function in action, logging into dbo.Autoscaler table so that it is possible to check what happened and why:

    250576-image.png

    Reference: Autoscaling Azure SQL Hyperscale


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.