SQLSERVER：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.

bubuko 2022/1/25 19:59:19 sqlserver 字数 932 阅读 997 0 来源 http://www.bubuko.com/infolist-5-1.html

1、Max Pool Size 默认为100。 2、查看当前数据库连接数量， select * from sysprocesses where dbid= db_id('数据库名称') 结果为190， 3、添加数据库查询的最大连接数量 Data Source=.;Initial Catalog=i_ ...

1、Max Pool Size 默认为100。

2、查看当前数据库连接数量，

select * from sysprocesses where dbid= db_id(‘数据库名称‘)

结果为190，

3、添加数据库查询的最大连接数量

Data Source=.;Initial Catalog=i_Master;Persist Security Info=True;User ID=NUser;Password=N2;max pool size=500
设置最大连接数量 500

SQLSERVER：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.

原文：https://www.cnblogs.com/topguntopgun/p/12658785.html

如果您也喜欢它,动动您的小指点个赞吧

除非注明，文章均由 laddyq.com 整理发布，欢迎转载。

转载请注明：
链接：http://laddyq.com
来源：laddyq.com
著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。

SQLSERVER：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.

分类汇总

您的鼓励是对我最大的支持