In Azure SQL servers you have the option of running vCore based “serverless” databases. In other words, databases that can auto-pause after a given delay (minimum is 15 minutes) and after that stop allocating running costs.
I wonder if anyone here has tried using that for Umbraco successfully.
The use case is not for a production environment, I should add. Rather dev environments or other either shortlived or low usage environments (think acceptance testing, feature testing or similar).
From my own testing, I had to first increase SQL connection string timeout to 60 seconds to not have it die out during an auto pause. But also doing that change means it keeps the database alive constantly, so it never pauses. Defeating the main purpose.
While we run Umbraco as a web app service we tried setting “always on” to false but no success that way either.
Anyone happen to know if you can configure Umbraco to not connect with the database if inactive for a while?