December 18, 2013 at 10:52 am
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.
December 19, 2013 at 9:36 am
Some more info if it helps:-
SQL Server 2008 R2 SP2 standard edition.
Database is Synchronous mirroring on the cloud.
December 20, 2013 at 4:25 am
See http://www.sqlservercentral.com/articles/System+Tables/66335 - it might help
December 20, 2013 at 8:58 am
Thank you very- very much. It helped.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply