Home Forums SQL Server 2008 SQL Server 2008 Administration HOW TO FIND the OFFENDING SESSION FROM sys.dm_tran_database transaction RE: HOW TO FIND the OFFENDING SESSION FROM sys.dm_tran_database transaction

  • May 6, 2013 at 5:44 am

    #1612592

    I think this might be posted on Ask.SQLServerCentral too. But you want to use sys.dm_tran_session_transactions. That will let you get transactions for a session or a session for a transaction.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning