I have an Azure SQL server hosting my database. For our current project this database should always be accessible and never be slept. The users should be able to log in to our app using their credentials, which is checked in the db, without having the server timeout error because the database server was asleep.
So I've tried modifying the auto-pause delay, using -1 as a parameters, then 0 has suggested by official microsoft documentation and even tried it at a value of 800 minutes. But no matter what values I give to the delay it always seem to pause itself after 15 to 60 minutes of inactivity.
We have a General Purpose Serverless Gen5 2vCores pricing tier.
Can anyone help me fix the auto-pause delay so that it doesn't pause or suggest a different approach to my problem.
Thanks in advance.
