Timeout expired.....

[Guest]

Hi

Iam working on asp.net web application and my web server is running on win2k
and data base is MS SQL 2000. Iam getting the below are error very frequently.

"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."

i havent used pooling attributes in my connection string and in IIS i had
put connections to unlimited....and most of the places i used datareaders and
iam closing datareaders after consuming them and explicitly closing the
connection as well as disposing the connection. But still iam getting the
above error.

when i see my Activity status in SQL Server under current activity of
management menu....i can see lot of connections are under sleep mode. i
re-started SQL server and even IIS and even iam doing the same for every 3 to
4 days.

I will be very thankfull to you if any one can mail me the solution.

Thanks in advance.

Regards
Vamsi

 

[Scott Allen]

Hi Vamsi:

If this problem occurs after a long period of time, you might need to
review your code and make absolutely sure you dispose the connections
when you are done. Do you have the dispose inside of a finally or
using statement?

Connection pooling happens by default with the SqlConnection class,
you don't need to put a special attribute in the string.

You might try to stress test pieces of your application with the
perfmon tool running to how your application uses connections.