Post reply

DORMANT Status

  • May 14, 2004 at 12:09 pm

    #102017

    I'm executing sp_who2 on a server and seeing the status of one of the processes as DORMANT. What is DORMANT and why would a process show as such?

    Thanks

  • May 14, 2004 at 12:53 pm

    #506531

     

    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. 

     

    bye

  • May 14, 2004 at 1:18 pm

    #506536

    that makes sense...usually I see this status when remote calls are made through the linked server....

    thanks for your reply....

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply