Azure SQL connection error

Question

Azure SQL connection error

Niren Adhikary (NAD) 146

Hi,

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

Nandan Hegde 27,241 Reputation points MVP

2022-08-19T07:09:12.38+00:00

Hey,
Can you tell what is the database tier?
And also show the logs for the compute utilization :

based on the error message it seems that the database is in max utilization capacity because of which it is timing out.
Once there are no activities, you can try accessing again.

other option would be to increase the tier
Niren Adhikary (NAD) 146 Reputation points

2022-08-19T07:11:52.863+00:00

Database tier : Standard S1: 20 DTUs. No elastic pool
Nandan Hegde 27,241 Reputation points MVP

2022-08-19T07:18:36.187+00:00

Hey, Are you able to access the database now ? Meaning was that error intermittent or is it still persistent?

And from where are you trying to access database? And code application?
If yes, In most cases connection pooling problems are related to connection leaks. Your application probably doesn't close its database connections correctly and consistently.
Niren Adhikary (NAD) 146 Reputation points

2022-08-19T07:20:07.987+00:00

error intermittent and connecting from an outsystem application
Nandan Hegde 27,241 Reputation points MVP

2022-08-19T07:22:29.167+00:00

Similar reference :
stackoverflow.com/questions/670774/how-can-i-solve-a-connection-pool-problem-between-asp-net-and-sql-server?rq=1

Nandan Hegde 27,241 Reputation points MVP

2022-08-19T07:09:12.38+00:00

Hey,
Can you tell what is the database tier?
And also show the logs for the compute utilization :

based on the error message it seems that the database is in max utilization capacity because of which it is timing out.
Once there are no activities, you can try accessing again.

other option would be to increase the tier
Niren Adhikary (NAD) 146 Reputation points

2022-08-19T07:11:52.863+00:00

Database tier : Standard S1: 20 DTUs. No elastic pool
Nandan Hegde 27,241 Reputation points MVP

2022-08-19T07:18:36.187+00:00

Hey, Are you able to access the database now ? Meaning was that error intermittent or is it still persistent?

And from where are you trying to access database? And code application?
If yes, In most cases connection pooling problems are related to connection leaks. Your application probably doesn't close its database connections correctly and consistently.
Niren Adhikary (NAD) 146 Reputation points

2022-08-19T07:20:07.987+00:00

error intermittent and connecting from an outsystem application
Nandan Hegde 27,241 Reputation points MVP

2022-08-19T07:22:29.167+00:00

Similar reference :
stackoverflow.com/questions/670774/how-can-i-solve-a-connection-pool-problem-between-asp-net-and-sql-server?rq=1

Answer 1

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.

Azure SQL connection error

1 answer

Activity