SQL Database auto-pause delay

Question

I don't see an option to change the auto-pause delay for my azure sql database. I'm looking under "Compute + Storage", scrolling to the bottom, and there are not control's for this.

I can see this is configured for 1 hour based on the "Overview -> Properties" tab.

My goal is to keep the db up during normal business hours and auto-pause at night. Any help would be greatly appreciated.

Answer 1

@Hunter K I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.

Issue: You are looking to change the auto-pause delay for your Azure SQL database. and want to keep the database up during normal business hours and auto-pause at night. you have checked under "Compute + Storage" and scrolled to the bottom but cannot find any controls for this. and also noticed that the auto-pause delay is currently set to 1 hour based on the "Overview -> Properties" tab.

Solution: As you mentioned yes if you have the free-tier applied, the options to change the auto-pause delay may not be visible. In that case, you will need to toggle off the free-tier on the same page "Compute + Storage" to access the auto-pause delay option. Once the free-tier is toggled off, the option to change the auto-pause delay should appear.

If you have any other questions or are still running into more issues, please let us know. Thank you again for your time and patience throughout this issue.

Please remember to "Accept Answer" if any answer/reply helped, so that others in the community facing similar issues can easily find the solution.

Regards

Geetha

Answer 2

I figured it out. If you have the free-tier applied these options are not shown. You'll need to toggle that off on the same page "Compute + Storage" then this option will appear.

Answer 3

Serverless will auto-pause after a minimum of 1 hour of inactivity. You can increase the "Auto-pause delay period" if you make a click on the "1 hour" link.

Then you can change the Auto-pause delay period.

Answer 4

Hi @Hunter K

You are correct; you can see that it is configured for 1 hour based on the "Overview -> Properties" tab, which is the default value (60 minutes) for Auto-pause delay. If you have enabled auto-pause, the database will pause after approximately 60 minutes if it meets the conditions below.

Auto-pausing is triggered if all of the following conditions are true during the auto-pause delay:

·        Number of sessions = 0

·        CPU = 0 for user workload running in the user resource pool

Thank You!