waitype = 0x0000, status = sleeping
-
waitype = 0x0000
status = sleeping
lastwaitype = PAGEIOLATCH_SH
The application never regains control and the SPID has to be killed. Any suggestions? However, from: http://support.microsoft.com/?scid=http://www.support.microsoft.com%2Fkb%2F822101%2F
Sleeping - SPID is not currently executing. This usually indicates that the SPID is awaiting a command from the application.
If the waittype is 0x0000, then the SPID is not currently waiting on anything and the lastwaittype value indicates the last waittype the SPID had.
Thank you for your assistance.
-
what is the spid id? < 50?
-
Thanks for your reply.
No, spid(s) involved are > 50
-
are you able to run a dbcc inputbuffer(spid#) to see what their last statement was?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply