First Connection to Azure SQL FreeDB takes 60 seconds

Robert Galante 61 Reputation points
2024-03-27T21:04:03.28+00:00

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?

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Rahul Randive 8,176 Reputation points Microsoft Employee
    2024-03-27T21:13:05.53+00:00

    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!


1 additional answer

Sort by: Most helpful
  1. ShaktiSingh-MSFT 13,271 Reputation points Microsoft Employee
    2024-03-31T07:53:49.6433333+00:00

    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.

    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

    0 comments No comments