First Connection to Azure SQL FreeDB takes 60 seconds

Question

I created a new Azure SQL Database using the FreeDB option. It's a serverless solution.

The first time I run a web application that accesses it, it takes 60 seconds or more to return a result.

After the first page, it is much more responsive. However, if I leave my desk, and the application sits for a while, the next operation takes 60 seconds or more to return a result.

This is way too slow, and I've seen it in two different subscription plans.

Is this normal behavior?

Answer 1

Hi Robert Galante

Yes, that seems to be latency for Azure SQL serverless database.

The latency to auto-resume and auto-pause a serverless database is generally order of 1 minute to auto-resume and 1-10 minutes after the expiration of the delay period to auto-pause.

Here is reference document- https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql&tabs=general-purpose#latency

Thank You!

Answer 2

Hi Robert Galante,

Welcome to Microsoft Q&A forum.

As I understand, you are using Free Azure SQL Database Serverless and you First Connection to Azure SQL FreeDB takes 60 seconds.

• Track usage throughout the month with the "Free amount remaining" Azure Metric. For more information, see Monitor and track service usage.
• Review the Azure SQL Database serverless auto-pause troubleshooting article for tips on saving vCore seconds.
• Disconnect querying tools such as Azure Data Studio and SQL Server Management Studio, including the Object Explorer, when you're done using them. Leaving connections open can continue to consume credits by preventing auto-pause.

References: https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer?view=azuresql

https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer-faq?view=azuresql&source=recommendations

Let us know if this helps or you have queries.

Thanks