This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 46%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Hi Team,
Is there any way we can shut down/Stop/Pause Non-Prod Azure SQL DB and Azure SQL MI during off business hrs to minimize the cost?
You can only pause and resume Azure SQL serverless. For other Azure SQL flavors (DTU-Model, vCore) you can schedule scale down of resources to the minimum service tier you can depending on the size of the database, so you can save money and minimize costs. No other option available.
How can we schedule scale down of resources?
I personally use Azure Automation. I use a runbook and from that runbook I issue statements like below:
# Execute the SQL command
$sqlCommand.CommandText= "ALTER DATABASE [YouDB] MODIFY (EDITION = 'Premium', MAXSIZE = 750 GB, SERVICE_OBJECTIVE = 'P6');"
$result = $sqlCommand.ExecuteNonQuery()
I have a database that scale up at 6:00 am on weekdays as P6 and after 6:30 pm and duirng weekends scale down to P2 as demand for resources is lower on weekends and during the night.