SQL Server Performance Forum – Threads Archive

sp_blocker script question

Hey guys, I found this sp_blocker athttp://support.microsoft.com/default.aspx?scid=kb;EN-US;271509 I ran this script in Query Analyzer. It returned me 7 separate results. Do I really need the other 6 results after the first 1? The first result outputs spid, status, blocked, waittime, cmd and so on. Thanks guys. V1rt

---

Check what are the blocked processess alongwith SP_who2 result. http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/en/wc082401/wct082401.asp KBA to analyze and collect the data. And kindly post one thread in relevant forums and I believe this threadhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4715 is related to this thread too. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>