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.
Autoscaling Azure SQL Hyperscale
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.
2 answers
Sort by: Most helpful
-
-
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:
Reference: Autoscaling Azure SQL Hyperscale