SGSCTC
asked on
The timeout period elapsed prior to obtaining a connection from the pool
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?
"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?
Last Comment
ASKER
how about IISPeek's impact on the performance? We need to make sure production enviornment won't be affected by our monitoring.
any other suggestions? I need to find a way to locate where it goes wrong.
any other suggestions? I need to find a way to locate where it goes wrong.
IISPeek's impact is negligible. It will enable you to find out if there's a page spinning and hanging up your application pool. It consumes less than 3%CPU and under 100MB RAM when I run it.
I don't know of another solution that would give you the information you need.
I don't know of another solution that would give you the information you need.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Web Development
Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.
78K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
http://iispeek.com/