Azure SQL connection error

Niren Adhikary (NAD) 146 Reputation points


We are getting below error while connection application to database.

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occured because all pooled connections were in use and max pool size was reached

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Dan Guzman 8,516 Reputation points

    The symptom of a timeout when retrieving a pooled connection can be due to various causes. Assuming the application does properly close/dispose connections (e.g. with a using block in C# or VB.NET), the symptom can be caused long-running queries (extended blocking or query/index tuning needed), undersized database tier, undersized, application tier, or slowness in retrieving large result sets.

    Examine activity during the problem timeframe to determine next steps to resolve.

    0 comments No comments