DTCXact - Log File growing.

• xponcall

  Old Hand

  Points: 312

  More actions

  September 29, 2011 at 1:21 pm

  #258144

  Log File is growing, upon running the DBCC opentran I get these result:

  Oldest active transaction:

  SPID (server process ID): 73

  UID (user ID) : -1

  Name : DTCXact

  LSN : (97742:426:2)

  Start time : Sep 16 2011 1:00:00:693PM

  SID : 0xcdade1c3dd69db49a018eb0fe7129fb6

  DBCC execution completed. If DBCC printed error messages, contact your system administrator.

  Anyone encounter this before?

  thanks

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 29, 2011 at 1:38 pm

  #1388616

  Have you investigated who, what, when and how of SPID 73?

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• aravind-305595

  Ten Centuries

  Points: 1389

  More actions

  January 2, 2012 at 1:51 am

  #1427332

  Hi,

  I am also encountering the same issue, could you please let me know it got solved.

• azdzn

  SSCarpal Tunnel

  Points: 4128

  More actions

  January 6, 2012 at 2:56 am

  #1429502

  It looks like a distributed query, ie. a query or stored procedure being executed on another server via a linked server (DTC is the Distributed Transaction Coordinator service).

  You can use DBCC INPUTBUFFER, fn_get_sql(), or Profiler to see exactly what the SPID is doing.