新机器的查询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
————————————————————