超时已过期。从池中获取连接之前经过的超时时间。这可能是因为所有池连接都在使用中并且达到了最大池大小 [英] 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

问题描述

我们已在Windows 2003 R2服务器64位和IIS 6.0中部署了Asp.net应用程序。



用户在10分钟后登录此应用程序，他得到以下提到的错误。



超时已过期。从池中获取连接之前已经过了超时时间。这可能是因为所有池连接都在使用中并且已达到最大池大小。





在应用程序方面，我们增加了连接池最小尺寸= 200和最大尺寸= 50000.



系统方面，我们在脚本下执行。



cscript％SYSTEMDRIVE％\inetpub \ adminscripts\adsutil.vbs SET W3SVC / AppPools / Enable32bitAppOnWin64 1



请建议我过来这个问题。

谢谢。

We have deployed Asp.net Application in Windows 2003 R2 server 64 bit and IIS 6.0.

The user login this application after 10 min, he is getting below mentioned 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."


In application side, We have increased connection pool Min size = 200 and Max size = 50000.

System side, we executed below script.

cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1

Please suggest me to over come this issue.
thanks.

推荐答案

查看这些博客

http://forums.asp.net/t/903456.aspx/1 [ ^ ]

HTTP：//www.code guru.com/csharp/.net/net_asp/article.php/c19395 [ ^ ]

--NDK

check these blogs
http://forums.asp.net/t/903456.aspx/1[^]
http://www.codeguru.com/csharp/.net/net_asp/article.php/c19395[^]
--NDK

错误是由于从数据库中检索数据



尝试在连接字符串中设置connectiontimeout属性



同时增加IIS中的时间



微调数据库查询





希望这有帮助

Hi,

The error is due to the retrieval of data from database

Try setting the connectiontimeout property in your connection string

Also increase the time out in IIS

Fine tune your db queries


Hope this helps

在连接字符串中添加最大池大小

Add Max Pool Size in your connection string

ex:-
<add name="entityConnection" connectionstring="metadata=res://*/EntityDB.csdl|res://*/EntityDB.ssdl|res://*/EntityDB.msl;provider=System.Data.SqlClient;provider connection string="Data Source=ServerName;Initial Catalog=DB_Name;Persist Security Info=True;User ID=sa;Password=password;<b>Max Pool Size=500</b>; MultipleActiveResultSets=True"" providername="System.Data.EntityClient" />

这篇关于超时已过期。从池中获取连接之前经过的超时时间。这可能是因为所有池连接都在使用中并且达到了最大池大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！