Share via

Azure Server/SQL Database Pausing an Instance

Jevon Davis 141 Reputation points
2021-12-07T01:33:25.007+00:00

Is there a way to not have SQL Server/Database running for 24 hours? I was looking on Just in Time Access but not sure if it achieves this. The costs associated with having it always up would be a bit expensive. Any solution to turn it on and off or pause it as a means of not being affected by billing costs too much?

Azure SQL Database
0 comments
Accepted answer
  1. Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
    2021-12-07T03:20:02.1+00:00

    My suggestion is to change the service tier to Serverless by making a click on the service tier:

    155521-image.png

    Change to serverless.

    155496-image.png

    Scroll down the screen and select the idle time the database will wait to get auto-paused.

    155458-image.png

    Here you will find more details about the auto-paused and auto-resume feature.

    You can schedule a scale up (changing just the auto-pause delay time) after business hours to kill any connections left to the database that can prevent the auto-pause to happen.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.