Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006

    Unanswered: Process Status "sleeping"

    I have processes running on the server that show a status of "sleeping" from sp_who and sysprocesses, however they are still running. I run sp_who over and over again and only occasionally the process status shows running, and then switches back to "sleeping" or "defwakeup". I know what all the statuses mean, I just don't know why a running process would ever show as "sleeping". The processes take a very very long time to run as well.

    Thanks in advance,

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 11
    The process is probably waiting on a disk read, while it is sleeping. What is the waittype from sysprocesses?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts