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,
SteveThe process is probably waiting on a disk read, while it is sleeping. What is the waittype from sysprocesses?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment