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

顯示結果從第 1 筆 到 3 筆,共計 3 筆
  1. #1
    會員
    註冊日期
    2001-07-04
    討論區文章
    44

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

    小弟是公司的兼職網管,所以有時會稍微注意一下網路狀況•
    因為我們內部都有一個共用系統,是全省連線的,但外地時常不能連,這時我的解決方法是把區域網路(系統為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^



  2. #2
    嘴炮戰隊隊長 ivantw 的大頭照
    註冊日期
    2002-05-04
    所在地區
    CHT FTTH 100M/20M Static IP
    討論區文章
    4,903
    把 SQL Server 的 Connection Timeout 及 Execute Timeout 設長一點試試。

  3. #3
    會員
    註冊日期
    2001-07-04
    討論區文章
    44
    最初由 Ivan Lin 發表
    把 SQL Server 的 Connection Timeout 及 Execute Timeout 設長一點試試。
    謝謝你的回應,但是.......
    要去哪裡調整呢?
    小弟對MS SQL實在是不太熟悉
    望請高手不吝指教

類似的主題

  1. 【求助】請問此張圖片上的啟動程式是否有異常的
    作者:iaa911 所在討論版:-- 防 駭 / 防 毒 版
    回覆: 5
    最後發表: 2006-01-18, 07:31 PM
  2. 網芳伺服器沒有異動功能
    作者:crisity 所在討論版:-- HELP ME 電 腦 軟 硬 體 急 救 版
    回覆: 0
    最後發表: 2004-08-29, 02:41 PM
  3. 【求助】Hinet網站查詢"連線資訊查詢"的結果!?
    作者:thomasho 所在討論版:---- ADSL 軟 硬 體 技 術
    回覆: 2
    最後發表: 2004-03-04, 04:20 PM
  4. 【求助】連線正常的顯示,卻開不網頁?
    作者:uqdo 所在討論版:-- HELP ME 電 腦 軟 硬 體 急 救 版
    回覆: 3
    最後發表: 2003-11-21, 02:11 PM
  5. 連接伺服器時 TCP/IP 發生錯誤
    作者:cwenkuei 所在討論版:-- 網 路 軟 體 討 論 一 版 (Browser,Email
    回覆: 0
    最後發表: 2002-02-01, 12:23 AM

 

此網頁沒有從搜尋引擎而來的訪客

發表文章規則

  • 不可以發表新主題
  • 不可以回覆文章
  • 不可以上傳附加檔案
  • 不可以編輯自己的文章
  •