none
how to count transactions done on your database by T-SQL query?

    Question

  • Dear All,

    I have multiple database and I want to know how many transaction that are happening per database using T-SQL, can anyone help me?

     

    Regards,

     

    Karim


    Karim Alaa
    Thursday, September 23, 2010 7:28 AM

Answers

  • Check both these DMVs..

    select * from sys.dm_tran_active_transactions
    select * from sys.dm_tran_session_transactions
    
    • Proposed as answer by Atif-ullah Sheikh Thursday, September 23, 2010 9:11 AM
    • Marked as answer by KJian_ Wednesday, September 29, 2010 7:50 AM
    Thursday, September 23, 2010 7:36 AM