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.

时间:2020-04-08 13:18:42   收藏:0   阅读:177

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

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

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!