The last few days we see this error message in our website too much:
“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.”
We have not changed anything in our code in a while. I revised the code to check open connections which didn’t close, but found everything to be fine.
-
How can I solve this?
-
Do I need to edit this pool?
-
How can I edit this pool’s max number of connections?
-
What is the recommended value for a high traffic website?
Update:
Do I need to edit something in IIS?
Update:
I found that the number of active connections are anywhere from 15 to 31, and I found that the max allowed number of connections configured in SQL server is more than 3200 connections, is 31 too many or should I edit something in the ASP.NET configration?