新机器的查询select lastwaittype,waitresource,waittime from sysprocesses order by waittime desc的结果：
------------------------------------------------------------
lastwaittype | waitresource | waittime
------------------------------------------------------------
RESOURCE_QUEUE | | 1020965938
------------------------------------------------------------
RESOURCE_QUEUE | | 3984
------------------------------------------------------------
RESOURCE_QUEUE | | 1063
------------------------------------------------------------
SLEEP | | 781
------------------------------------------------------------
PAGEIOLATCH_SH | 1:1:140 | 0
------------------------------------------------------------
CMEMTHREAD | | 0
------------------------------------------------------------
RESOURCE_QUEUE | | 0
------------------------------------------------------------
MISCELLANEOUS | | 0
------------------------------------------------------------
WRITELOG | | 0
------------------------------------------------------------
MISCELLANEOUS | | 0
------------------------------------------------------------
LATCH_EX | MISC (00C45DF8) | 0
------------------------------------------------------------
LATCH_EX | MISC (00C45DF8) | 0
------------------------------------------------------------
WRITELOG | | 0
------------------------------------------------------------
WRITELOG | | 0
------------------------------------------------------------
WRITELOG | | 0
------------------------------------------------------------
NETWORKIO | | 0
------------------------------------------------------------
NETWORKIO | | 0
------------------------------------------------------------
NETWORKIO | | 0
------------------------------------------------------------
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
