Post reply

Identify a running transaction in SQL Server

  • November 8, 2010 at 1:47 am

    #242688

    When i run the following query:

    SELECT transaction_id

    FROM sys.dm_tran_active_snapshot_database_transactions

    ORDER BY elapsed_time_seconds DESC;

    I get the ID for a transaction that is currently running. But, how can I manage to find more information about this transaction. It makes by tempdb grow without control. I would like to find out as much as possible about this transaction. Please help.

    /Andy.l

  • November 8, 2010 at 2:04 am

    #1247533

    andy.l (11/8/2010)

    When i run the following query:

    SELECT transaction_id

    FROM sys.dm_tran_active_snapshot_database_transactions

    ORDER BY elapsed_time_seconds DESC;

    I get the ID for a transaction that is currently running. But, how can I manage to find more information about this transaction. It makes by tempdb grow without control. I would like to find out as much as possible about this transaction. Please help.

    /Andy.l

    sp_who2

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • November 8, 2010 at 3:12 am

    #1247549

    or sp_who2 'active'

  • November 8, 2010 at 7:04 am

    #1247644

    DBCC INPUTBUFFER(SPID)

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

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

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