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:
-
Is it possible to change the settings so the Database only goes into the Light Pause and never the Deep Pause?
-
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.
-
Is there some other alternative different from 1 or 2 above that would eliminate the Deep Pause?
Read more here: Source link

