Issues when logging back into the database after idle timeout

Question

If you try the application to log back into the database after it is idle timeout, it will connect to the second attempt without doing it all at once. The current application has me retrying about 3 times, so I don't get the error, but the login time is taking as long as 20 seconds. I wonder if it's because of the free plan or if it's a setup issue.

Answer 1

I'd increase the tier of the database, ensure you can connect and start looking into queries that are taking the most utilization, or database size, or number of connections.

So, yes it is possible it is a free plan or tier issue. consider upgrading the database sku.

https://azure.microsoft.com/en-us/pricing/details/azure-sql-database/single/

You can mark it 'Accept Answer' and 'Upvote' if this helped you

Regards,

Abiola