tripri
SSCommitted
Points: 1584
More actions
May 13, 2013 at 7:38 am
#272668
Hi ,
I got some sessions blocked by spid -2. But i'm not sure what exaclty is -2 meant by, i tried to do some research on that but couldn't get enough info. So can some one help me out on that please.
Adi Cohn-120898
SSC-Dedicated
Points: 33944
May 13, 2013 at 7:52 am
#1614595
This is an orphaned DTC transaction. Unfortunately it still holds locks and causes blocking. The fallowing URL contains explanations and the way to kill this process http://www.sqlserverclub.com/articles/how-to-deal-with-negative-spids-in-sql-server.aspx
Adi
--------------------------------------------------------------To know how to ask questions and increase the chances of getting asnwers:http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply