数据库连接池已满 [英] DB Connection Pool Full

问题描述

问候全部，

最近我的门户网站继续显示以下错误消息。

Recently my web portal keep on showing below error message.

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

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.

我检查了具有大约217个具有相同登录连接的特定数据库，157个连接状态显示正在运行， 60个连接状态显示正在休眠。目前，此数据库已打开服务代理，157个连接是服务
代理会话。任何解决最大池大小的建议都达到了错误信息？谢谢。

I checked that particular database which has around 217 connections with same login, 157 connections status is showing running and 60 connections status is showing sleeping. Currently this db is turn on with service broker and 157 connections are service broker session. Any suggestion to solve the max pool size was reached error message? Thank you.

问候，

Justin

推荐答案

检查SQL Server上的服务器最大连接数设置，这将重置它...

check your server max connections setting on SQL Server, this will reset it...

1. sp_configure '用户连接' ， 0
2. go
3. reconfigure 覆盖

1. sp_configure 'user connections', 0
2. go
3. reconfigure with override

https://ask.sqlservercentral.com/questions/1755/how-to-increase-the-connection-pool-尺寸在-SQL se.html

https://ask.sqlservercentral.com/questions/1755/how-to-increase-the-connection-pool-size-in-sql-se.html

https://www.pythian.com/blog/sql-server-understanding-and-controlling-connection/

https://www.pythian.com/blog/sql-server-understanding-and-controlling-connection/

这篇关于数据库连接池已满的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！