SQL Server Performance Forum – Threads Archive
Strange! Blocked by self!
Who can explain this case? spid ecid status loginame host blk dbname cmd ……131 0 sleeping sa AAA 0 Te select
131 4 sleeping sa AAA 0 Te select
131 3 sleeping sa AAA 131 Te select
131 2 sleeping sa AAA 131 Te select
131 1 sleeping sa AAA 131 Te select The spid is blocked by itself?
Thanks in advance!
This is normal behaviour after sp4 I believe. Read the following thread. http://www.mcse.ms/message1609509.html.
quote:Originally posted by yitangliang
Who can explain this case?
spid ecid status loginame host blk dbname cmd ……
131 0 sleeping sa AAA 0 Te select
131 4 sleeping sa AAA 0 Te select
131 3 sleeping sa AAA 131 Te select
131 2 sleeping sa AAA 131 Te select
131 1 sleeping sa AAA 131 Te select The spid is blocked by itself?
Thanks in advance!
131 0 sleeping sa AAA 0 Te select
131 4 sleeping sa AAA 0 Te select
131 3 sleeping sa AAA 131 Te select
131 2 sleeping sa AAA 131 Te select
131 1 sleeping sa AAA 131 Te select The spid is blocked by itself?
Thanks in advance!
Karl Grambow www.sqldbcontrol.com
Hi, <br />please refer previously discussed thread in this regards, here are some FYI :<br /><br /<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10842>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10842</a><br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
]]>