Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Blocking from -4 SPID

Author  Topic 

mey72
Starting Member

1 Post

Posted - 2012-06-01 : 11:03:46
In the last 2 weeks I have seen excessive blocking by a -4 SPID. We have not changed anything lately.

Does anyone know what would be causing the -4 SPID?

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2012-06-01 : 11:46:20
FWIW, I've never seen a negative SPID.

=================================================
There is a foolish corner in the brain of the wisest man. -Aristotle, philosopher (384-322 BCE)
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-06-01 : 13:25:01
Try this:

http://www.sqlserverclub.com/articles/how-to-deal-with-negative-spids-in-sql-server.aspx

The -2 SPID is an orphaned distributed transaction, not sure if -4 is the same but the process for killing it may still apply.
Go to Top of Page
   

- Advertisement -