【求助】伺服器時常癱瘓，查詢連線資料都有異常的顯示

[tigerlin901]

小弟是公司的兼職網管，所以有時會稍微注意一下網路狀況•
因為我們內部都有一個共用系統，是全省連線的，但外地時常不能連，這時我的解決方法是把區域網路(系統為2000，兩張網卡一張對內一張對外)的WAN port 重新啟動，但一天都必須要重新啟動好幾次！而我用 netstat -a 查的資料如下：

---------------------------------------------------------------------
Active Connections

Proto Local Address Foreign Address State
TCP misserver:epmap misserver:0 LISTENING
TCP misserver:https misserver:0 LISTENING
TCP misserver:microsoft-ds misserver:0 LISTENING
TCP misserver:1027 misserver:0 LISTENING
TCP misserver:1028 misserver:0 LISTENING
TCP misserver:1029 misserver:0 LISTENING
TCP misserver:1030 misserver:0 LISTENING
TCP misserver:1037 misserver:0 LISTENING
TCP misserver:1040 misserver:0 LISTENING
TCP misserver:3372 misserver:0 LISTENING
TCP misserver:3389 misserver:0 LISTENING
TCP misserver:3509 misserver:0 LISTENING
TCP misserver:3520 misserver:0 LISTENING
TCP misserver:3526 misserver:0 LISTENING
TCP misserver:4899 misserver:0 LISTENING
TCP misserver:5631 misserver:0 LISTENING
TCP misserver:6129 misserver:0 LISTENING
TCP misserver:info-was misserver:0 LISTENING
TCP misserver:info-cachesvr misserver:0 LISTENING
TCP misserver:info-pagesvr misserver:0 LISTENING
TCP misserver:8009 misserver:0 LISTENING
TCP misserver:8012 misserver:0 LISTENING
TCP misserver:ms-sql-s misserver:0 LISTENING
TCP misserver:ms-sql-s misserver:0 LISTENING
TCP misserver:netbios-ssn misserver:0 LISTENING
TCP misserver:ms-sql-s misserver:0 LISTENING
TCP misserver:netbios-ssn misserver:0 LISTENING
TCP misserver:1027 misserver:3509 ESTABLISHED
TCP misserver:1029 misserver:3520 ESTABLISHED
TCP misserver:1029 misserver:3526 ESTABLISHED
TCP misserver:ms-sql-s misserver:0 LISTENING
TCP misserver:3509 misserver:1027 ESTABLISHED
TCP misserver:3520 misserver:1029 ESTABLISHED
TCP misserver:3526 misserver:1029 ESTABLISHED
TCP misserver:3725 misserver:info-cachesvr TIME_WAIT
TCP misserver:3736 misserver:info-cachesvr TIME_WAIT
TCP misserver:3743 misserver:0 LISTENING
TCP misserver:3743 MISSERVERRR:netbios-ssn ESTABLISHED
TCP misserver:info-cachesvr misserver:3721 TIME_WAIT
TCP misserver:info-cachesvr misserver:3722 TIME_WAIT
TCP misserver:info-cachesvr misserver:3723 TIME_WAIT
TCP misserver:info-cachesvr misserver:3724 TIME_WAIT
TCP misserver:info-cachesvr misserver:3726 TIME_WAIT
TCP misserver:info-cachesvr misserver:3727 TIME_WAIT
TCP misserver:info-cachesvr misserver:3728 TIME_WAIT
TCP misserver:info-cachesvr misserver:3729 TIME_WAIT
TCP misserver:info-cachesvr misserver:3730 TIME_WAIT
TCP misserver:info-cachesvr misserver:3731 TIME_WAIT
TCP misserver:info-cachesvr misserver:3732 TIME_WAIT
TCP misserver:info-cachesvr misserver:3733 TIME_WAIT
TCP misserver:info-cachesvr misserver:3734 TIME_WAIT
TCP misserver:info-cachesvr misserver:3735 TIME_WAIT
TCP misserver:info-cachesvr misserver:3737 TIME_WAIT
TCP misserver:info-cachesvr misserver:3738 TIME_WAIT
TCP misserver:info-cachesvr misserver:3739 TIME_WAIT
TCP misserver:info-cachesvr misserver:3740 TIME_WAIT
TCP misserver:info-cachesvr misserver:3741 TIME_WAIT
TCP misserver:info-cachesvr misserver:3742 TIME_WAIT
TCP misserver:info-cachesvr misserver:3744 TIME_WAIT
TCP misserver:info-cachesvr misserver:3745 TIME_WAIT
TCP misserver:info-cachesvr misserver:3746 TIME_WAIT
TCP misserver:info-cachesvr misserver:3747 TIME_WAIT
TCP misserver:8012 192.168.100.253:33093 ESTABLISHED
TCP misserver:8012 192.168.100.253:33098 ESTABLISHED
TCP misserver:8012 192.168.100.253:37215 ESTABLISHED
TCP misserver:8012 192.168.100.253:37223 TIME_WAIT
TCP misserver:8012 192.168.100.253:37225 TIME_WAIT
TCP misserver:8012 192.168.100.253:37227 TIME_WAIT
TCP misserver:8012 192.168.100.253:37240 TIME_WAIT
TCP misserver:8012 192.168.100.253:37244 TIME_WAIT
TCP misserver:8012 192.168.100.253:37246 TIME_WAIT
TCP misserver:8012 192.168.100.253:37248 TIME_WAIT
TCP misserver:8012 192.168.100.253:37249 TIME_WAIT
TCP misserver:8012 192.168.100.253:37252 TIME_WAIT
TCP misserver:8012 192.168.100.253:37253 TIME_WAIT
TCP misserver:8012 192.168.100.253:37358 TIME_WAIT
TCP misserver:8012 192.168.100.253:37360 TIME_WAIT
TCP misserver:8012 192.168.100.253:37361 TIME_WAIT
TCP misserver:8012 192.168.100.253:37565 TIME_WAIT
TCP misserver:8012 192.168.100.253:37566 TIME_WAIT
TCP misserver:8012 192.168.100.253:37568 TIME_WAIT
TCP misserver:8012 192.168.100.253:37569 TIME_WAIT
TCP misserver:8012 192.168.100.253:37570 TIME_WAIT
TCP misserver:8012 192.168.100.253:37573 TIME_WAIT
TCP misserver:8012 192.168.100.253:37577 TIME_WAIT
TCP misserver:8012 192.168.100.253:37578 TIME_WAIT
TCP misserver:8012 192.168.100.253:37579 TIME_WAIT
TCP misserver:8012 192.168.100.253:37580 TIME_WAIT
TCP misserver:8012 192.168.100.253:37583 TIME_WAIT
TCP misserver:8012 211.75.234.50:62631 TIME_WAIT
TCP misserver:8012 211.75.234.50:62632 TIME_WAIT
UDP misserver:epmap *:*
UDP misserver:microsoft-ds *:*
UDP misserver:1033 *:*
UDP misserver:1122 *:*
UDP misserver:ms-sql-m *:*
UDP misserver:3456 *:*
UDP misserver:5632 *:*
UDP misserver:isakmp *:*
UDP misserver:netbios-ns *:*
UDP misserver:netbios-dgm *:*
UDP misserver:isakmp *:*
UDP misserver:netbios-ns *:*
UDP misserver:netbios-dgm *:*
UDP misserver:isakmp *:*
------------------------------------------------------------------
我用自己的主機查詢也不過15個項目，以上為公司的伺服器，項目異常的多，請各位高手幫我一下吧！謝謝~~~^0^

[ivantw]

把 SQL Server 的 Connection Timeout 及 Execute Timeout 設長一點試試。

[tigerlin901]

最初由 Ivan Lin 發表
把 SQL Server 的 Connection Timeout 及 Execute Timeout 設長一點試試。

謝謝你的回應，但是.......
要去哪裡調整呢？
小弟對MS SQL實在是不太熟悉
望請高手不吝指教