June 1, 2009 at 12:39 pm
Hi
Iam running a sp_who2 and I notice that some of them have status as DORMANT.
What does this mean.
Thanks
June 1, 2009 at 9:29 pm
Hi,
Below is the meaning of DORMANT.
DORMANT
*********
Same as "sleeping", except a "DORMANT" SPID was reset after completing an RPC event from remote system (possibly a linked server). This cleans up resources and is normal; the SPID is available to execute. The system may be caching the connection. Replication SPIDs show "DORMANT" when waiting.
Regards
GURSETHI
June 1, 2009 at 11:35 pm
thank You GURSETHI...
its a linked server..
June 29, 2009 at 1:21 pm
Is there a list of the Status types and meanings?
Peter Cwik
January 30, 2010 at 9:37 am
Hi,
Please check this MSDN link.
http://msdn.microsoft.com/en-us/library/ms174313.aspx
also
http://support.microsoft.com/kb/822101
Hope it will help.
Regards
GURSETHI
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply