Post reply

DTCXact - Log File growing.

  • 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

  • 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

  • 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.

  • 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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply