重分求教一个mssql疑难问题,请高手进来看看:
MSSQL2000+sp3,双机热备;每台机子各有一个SQL实例,其中一台发生怪问题,每隔一段时间会死机,就是键盘鼠标动不了,但sql server的进程还在运行,也就是说还可以访问库,只是非常慢,只能重启,很纳闷,进程中又没有非常的进程,不懂是什么造成这些情况的,看日志有如下报错,贴出一部份了来,直到重启电脑后才正常
调度程序 0 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05EF0288"
2008-9-11 2:21:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 3 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05F3E978"
2008-9-11 2:21:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 2 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05F34EA8"
2008-9-11 2:21:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 1 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05EC9018"
2008-9-11 2:21:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 0 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05EF0288"
2008-9-11 2:20:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 3 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05F3E978"
2008-9-11 2:20:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 2 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05F34EA8"
2008-9-11 2:20:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 1 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05EC9018"
2008-9-11 2:20:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 0 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05EF0288"
2008-9-11 2:19:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 3 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05F3E978"
2008-9-11 2:19:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 2 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05F34EA8"
2008-9-11 2:19:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 1 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05EC9018"
2008-9-11 2:19:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 0 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05EF0288"
2008-9-11 2:18:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 3 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05F3E978"
2008-9-11 2:18:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 2 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05F34EA8"
2008-9-11 2:17:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 3 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05F3E978"
2008-9-11 2:17:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 2 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05F34EA8"
2008-9-11 2:16:06 MSSQLSERVER 信息 (2) 17052 N/A HIS "错误: 17883,严重度: 1,状态: 0
调度程序 2 似乎已被挂起。SPID 0,ECID 0,UMS 上下文 0x05F34EA8"
2008-9-11 2:15:53 MSSQLSERVER 错误 (3) 17052 N/A HISSLAVE "[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][ODBC SQL Server Driver]通讯链接失败
"
2008-9-11 2:15:53 MSSQLSERVER 错误 (3) 17052 N/A HISSLAVE "[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
"
2008-9-11 2:15:53 MSSQLSERVER 错误 (3) 17052 N/A HISSLAVE "[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][ODBC SQL Server Driver]通讯链接失败
"
2008-9-11 2:15:53 MSSQLSERVER 错误 (3) 17052 N/A HISSLAVE "[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
"
2008-9-11 2:15:53 MSSQLSERVER 错误 (3) 17052 N/A HISSLAVE "[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][ODBC SQL Server Driver]通讯链接失败
"
2008-9-11 2:15:53 MSSQLSERVER 错误 (3) 17052 N/A HISSLAVE "[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
"
2008-9-11 2:15:53 MSSQLSERVER 错误 (3) 17052 N/A HISSLAVE "[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][ODBC SQL Server Driver]通讯链接失败
"
2008-9-11 2:15:53 MSSQLSERVER 错误 (3) 17052 N/A HISSLAVE "[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
"
2008-9-11 2:15:53 MSSQLSERVER 错误 (3) 17052 N/A HISSLAVE "[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][ODBC SQL Server Driver]通讯链接失败
"
2008-9-11 2:15:53 MSSQLSERVER 错误 (3) 17052 N/A HISSLAVE "[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
"
2008-9-11 2:15:53 MSSQLSERVER 错误 (3) 17052 N/A HISSLAVE "[sqsrvres] OnlineThread: QP is not online.
"
2008-9-11 2:15:53 MSSQLSERVER 错误 (3) 17052 N/A HISSLAVE "[sqsrvres] printODBCError: sqlstate = HY018; native error = b; message = [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]一般性网络错误。请检查网络文档。
"
2008-9-11 2:15:53 MSSQLSERVER 错误 (3) 17052 N/A HISSLAVE "[sqsrvres] printODBCError: sqlstate = 01000; native error = 2746; message = [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send()).
"
2008-9-11 2:15:53 MSSQLSERVER 错误 (3) 17052 N/A HISSLAVE "[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed