Azure Serverless Deep Pause vs Light Pause

I currently have my Azure SQL Serverless database on 15 minutes auto-pause. If the database is inactive for 15 minutes it goes into a light pause, meaning records are fetched in 4-6 seconds instead of the usual 2 seconds on the first fetch after the pause. However, if the database has been on pause for several hours overnight, it appears to go into a deep pause. After this deep pause it takes 1 minute to fetch the records.

I would like to avoid the Deep Pause:

  1. Is it possible to change the settings so the Database only goes into the Light Pause and never the Deep Pause?

  2. If 1 is not possible, how man hours of pause does it take before Azure switches to the Deep Pause? If it’s for 4 hours then I can setup a program that will always do a simple Query every 3.75 hours for example.

  3. Is there some other alternative different from 1 or 2 above that would eliminate the Deep Pause?

Azure Serverless

Read more here: Source link