SQL Server 2005 Sleeping SPID blocking another SPID...
Posted
by user173552
on Stack Overflow
See other posts from Stack Overflow
or by user173552
Published on 2010-04-28T21:51:33Z
Indexed on
2010/04/28
21:57 UTC
Read the original article
Hit count: 337
I find many sleeping process my SQL Server database and looks like one of those sleeping SPIDs is blocking another process, and that process is getting suspended too...
Could some one please explain this...
1.) How can a sleeping process block another process? 2.) I see many sleeping process...is this normal?
Thanks
© Stack Overflow or respective owner