September 17, 2010 at 12:25 pm
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
September 17, 2010 at 1:44 pm
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.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply