Question

Your company runs a provisioned vCore Azure SQL Database that experiences heavy batch processing every weekend and light activity on weekdays. Management wants to automatically scale the database up to a higher service objective on Friday evening and scale it back down on Monday morning to reduce cost, with no dedicated server to host SQL Server Agent. The solution must run unattended and require minimal ongoing administration. Which approach should you implement?

Accepted Answer

Create an Azure Automation account with a PowerShell runbook that calls Set-AzSqlDatabase, and link two schedules to run the scale-up and scale-down operations.

Answer

Create a SQL Server Agent job on the Azure SQL Database with two schedules that execute ALTER DATABASE ... MODIFY (SERVICE_OBJECTIVE = ...).

Answer

Configure an Elastic Job agent with a target group pointing at the database and schedule a T-SQL job that changes the service tier.

Answer

Create an Azure Monitor alert on CPU percentage that triggers a Logic App to resize the database each time the threshold is crossed.