SQL Server Performance Forum – Threads Archive
sp_blocker script questionHey 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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.