SQL Server Performance Forum – Threads Archive
Connection pool time out
I am receiving the following 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. I am getting this error when I put the SQL server on a 2003 server that is also running IIS. If I run the SQL server from a 2000 server that is not running IIS, the server will run slow but I don’t receive the error. Everything I have read states I’m not closing connections. Is there anything else that could be giving this error? Thankshi i guess v get that error coz of the network bandwidth prob…but then another prb cud be coz of the IIS installed on the same machine as SQL server… it may be this way tat u dont have enough memory for the SQL server… Network Bandwidth prbm can be like this … u send a request and the request is granted but then coz of the traffic on the n/w tat grant packet may reach u after some delay and that delay is more than ur timeout… Regards
Suleman
Hyderabad
refer to this article of microsoft. see if it helps. http://support.microsoft.com/default.aspx?scid=kb;en-us;830118
]]>