Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

blocked by spiD -2 Expand / Collapse
Author
Message
Posted Monday, May 13, 2013 7:38 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, January 4, 2014 10:46 PM
Points: 82, Visits: 340
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.
Post #1452099
Posted Monday, May 13, 2013 7:52 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:23 AM
Points: 2,115, Visits: 5,429
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/
Post #1452105
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse