Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

process status in sp_who

Status
Not open for further replies.

oneshadow

IS-IT--Management
Dec 23, 2004
125
ID
if we run sp_who from Query Analyzer, we can see current process ID and their status. Can somebody tell me what's the meaning of :

1. sleeping
2. AWAITING COMMAND ?

I've been search for MSDN with no luck.

thanks in advance
 

Sleeping: SPID is not currently executing. This usually indicates that the SPID is awaiting a command from the application.

Awaiting Command: The SPID is waiting for the next command. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top