SPID with DORMANT status

• Gordon Pollokoff

  SSCommitted

  Points: 1930

  More actions

  September 17, 2010 at 12:25 pm

  #95076

  I am encountering an issue with a call from a LinkedServer that is causing excessive blocking. The SPID shows a status of DORMANT. This just started happening after doing some maintenance on our cluster and I am at a loss to explain why a) the SPID is showing DORMANT for an extented period and b) why it would still be holding a lock if it is DORMANT ?

  Any and all suggestions would help!

  Gordon Pollokoff

  "Wile E. is my reality, Bugs Bunny is my goal" - Chuck Jones

• Meet George Jetson

  SSChampion

  Points: 11680

  More actions

  September 17, 2010 at 1:44 pm

  #1223301

  A status of Dormant is considered the same as Sleeping, with the exception that a status of Dormant means 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.

  Please take a look at the following Microsoft support reference

  http://support.microsoft.com/default.aspx?scid=kb;en-us;224453

  Chris Powell

  George: You're kidding.
  Elroy: Nope.
  George: Then lie to me and say you're kidding.