December 14, 2005 at 2:06 pm
Question
In sp_who2 or Current Activity, What does the staus column represent.
84 sleeping
86 sleeping
87 sleeping
88 sleeping
89 DEFWAKEUP
90 sleeping
91 sleeping
I couldn't find anything in BOL concerning this. Maybe I'm serching the wrong way.
What does Sleepng mean vs. Runable? What in the hell is DFWWAKEUP?
December 15, 2005 at 5:48 pm
sleeping - waiting on disk I/O or some other resource, also means that process is running extensive disk I/O. Also indicates if connection is made to the database and doing nothing
runnable - in the queue of runaable/running processes
DEFWAKEUP - usually refering to server process, a process being activated to do some background jobs after sleeping for sometimes.
should also check out the commands what the process is doing.
December 15, 2005 at 5:50 pm
sleeping - waiting on disk I/O or some other resource, also means that process is running extensive disk I/O. Also indicates if connection is made to the database and doing nothing
runnable - in the queue of runaable/running processes
DEFWAKEUP - usually refering to server process, a process being activated to do some background jobs after sleeping for sometimes.
should also check out the commands what the process is doing.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply