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 -4 Expand / Collapse
Author
Message
Posted Wednesday, December 18, 2013 10:52 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 4:01 PM
Points: 835, Visits: 1,192
Today I saw massive blocking in one of my production database instance. On looking further I found that some of the transactions being blocked by SPID-4. I was totally clueless.

I know SPID -2 related to orphaned DTC and -3 is deferred transaction. I have never before heard of or seen -4 SPID.

I would like to know if anybody has seen this before or what may have caused this.

Thanks for your help in advance.
Post #1524245
Posted Thursday, December 19, 2013 9:36 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 4:01 PM
Points: 835, Visits: 1,192
Some more info if it helps:-
SQL Server 2008 R2 SP2 standard edition.
Database is Synchronous mirroring on the cloud.
Post #1524685
Posted Friday, December 20, 2013 4:25 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:55 AM
Points: 2,714, Visits: 2,321
See http://www.sqlservercentral.com/articles/System+Tables/66335 - it might help
Post #1524928
Posted Friday, December 20, 2013 8:58 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 4:01 PM
Points: 835, Visits: 1,192
Thank you very- very much. It helped.
Post #1525041
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse