Can someone please tell me how a spid gets to be in a 'DORMANT' state? What
is the difference between 'dormant' and sleeping? It appears that the
'dormant' processes cannot be killed. Can't find anything on Microsoft's
website pertaining to this. Any help with this would be appreciated.From MSKB 224453:
<Excerpt
href="http://support.microsoft.com/default.aspx?scid=kb;en-us;224453:">
Dormant 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.
</Excerpt>
Hope this helps.
Dan Guzman
SQL Server MVP
"Farbro" <Farbro@.discussions.microsoft.com> wrote in message
news:DBCCEE89-AF96-4A20-B375-549AAECFB32A@.microsoft.com...
> Can someone please tell me how a spid gets to be in a 'DORMANT' state?
> What
> is the difference between 'dormant' and sleeping? It appears that the
> 'dormant' processes cannot be killed. Can't find anything on Microsoft's
> website pertaining to this. Any help with this would be appreciated.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment