2016年2月26日 星期五

已超過連接逾時的設定,並已達共用集區大小的最大值



解決辦法:(沒實際試過僅供參考)

1.
ASP.NET預設連結資料庫的Connection數為100個,在Connection String裡加入Max Pool Size=xxx的設定

2.
重啓SQL資料庫的服務


查詢目前DB連線數

USE master
 SELECT cntr_value AS User_Connections FROM sys.sysperfinfo AS sp
 WHERE sp.object_name='SQLServer:General Statistics'
 AND sp.counter_name='User Connections'

目前DB有哪些連線


USE master
 SELECT c.session_id, c.connect_time, s.login_time, c.client_net_address, s.login_name, s.status
 FROM sys.dm_exec_connections c left join sys.dm_exec_sessions s on c.session_id = s.session_id
 

2 則留言:

  1. He vowed that sports activities betting would not pass with out VLTs, which the casinos lobbying for sports activities betting have opposed. Minnesota came extraordinarily near legalizing sports activities betting in 2022 and lawmakers 토토사이트 will probably take it up once more in 2023. California is essentially the most populous U.S. state and regarded the crown jewel of the sports activities betting market. If you live in the Golden State, expect tons of advertisements concerning the proposals leading a lot as} November.

    回覆刪除

熱門文章