The timeout period elapsed prior to obtaining a connection from the pool
Posted on 2011-10-09
We have a web site running on .net + sql server. Recently we are getting the below error:
"Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool.
This may have occurred because all pooled connections were in use and max pool size was reached. Inner Exception:>>"
It occured not very often. 4,5 times in the last year. The website will return to normal after restarting IIS.
This error clearly states that applicaiton pool have reached the max pool size and it does not have any more connection left for the application to be made to SQL Server.
We doubt that in the code, database connections are being opened but never closed. However, after examining some suspecious moduels, we could not find any of this type of connection. All connections are closed properly.
Is there any way to trouble shoot this problem or to locate the exact problematic point?