Difference about running and runnable

Hi,
Anybody know the difference about running and runnable when I execute sp_who
?
Thanks in advance,
VitorFrom what I know the status column of sysprocesses table can have one of the
following values:
Status Meaning
----
----
Background SPID is performing a background task.
Sleeping SPID is not currently executing. This usually indicates
that the SPID is awaiting a command from the application.
Runnable SPID is currently executing.
Dormant Same as Sleeping, except Dormant also indicates that the
SPID has been reset after completing an RPC event. The reset cleans up
resources used during the RPC event. This is a normal state and the SPID is
available and waiting to execute further commands.
Rollback The SPID is in rollback of a transaction.
Defwakeup Indicates that a SPID is waiting on a resource that is in
the process of being freed. The waitresource field should indicate the
resource in question.
Spinloop Process is waiting while attempting to acquire a
spinlock used for concurrency control on SMP systems.
I found a description for "Running" status in a Sybase Manual:
"running:Actively running on one of the server engines" and in the same
manual "runnable: In the queue of runnable processes".
"Killing processes"
/5162" target="_blank">http://manuals.sybase.com/onlineboo...ew
/5162
HTH,
Cristian Lefter, SQL Server MVP
"Vitor Mauricio de N. Silva" <vitor_mauricio@.terra.com.br> wrote in message
news:u3A6edKXFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Anybody know the difference about running and runnable when I execute
> sp_who ?
> Thanks in advance,
> Vitor
>sql