Hi there,

Can somebody tell me the differences between SLEEPING and RUNNING
processes? I cannot find an explaination in BOL. If there is a thread on
this issue somewhere, can you put a link?

Tnx,

Hans Brouwer

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

sleeping status indicates that the SPID has completed execution and is
waiting for the application to submit another query or batch. A runnable
status indicates the SPID is currently processing a query

See

INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
PSS ID Number: 224453

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Hans Brouwer" <hansbrouwer (AT) hotmail (DOT) com> wrote

Tnx Allan, the article sure helped. It also raised another question.
RUNNABLE indicates SPID is executing. What does RUNNING indicate, then?
I would asume the latter would indicate executing...

Tnx,

Hans Brouwer

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

According to the table it doesn't exist. I can't think I've seen it either.
Where do you see it exactly?

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Hans Brouwer" <hansbrouwer (AT) hotmail (DOT) com> wrote

In BOL under Monitoring with SQL Server Enterprise Manager under the
description of the item Status

Tnx,

Hans Brouwer

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

In BOL, under Monitoring SQL Server with the Enterprise manager, under
description for item STATUS.

Tnx,

Hans Brouwer

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Hans,

Thanks for your feedback. As I understand, Sp_who provides information
about current Microsoft SQL Server users and processes, which are fetched
from the sysprocesses system table. Based on my research, in the result set
returned from the stored procedure sp_who and the sysprocesses system
table, we are unable to get the RUNNING status of SQL Server process, but
the RUNNABLE status. A RUNNABLE status indicates the SPID is currently
processing a query.

Thanks for using MSDN newsgroup.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.