Post reply

Transactions Hitting a Database

  • July 27, 2009 at 3:41 am

    #132324

    Hi All

    I am using SQL Server2005 (64Bit), is there any way to find out how many transactions that hit each database per sec 🙂

    Thanks in advance for all your help

  • July 27, 2009 at 6:47 am

    #1030466

    Performance Monitor is traditionally the place to get this kind of information. You can look at the counter Database:Transactions/Sec:DBName to get the transactions/sec for any given database or use the _Total to get the server transactions.

    You can also query the sys.dm_tran_* dynamic management views to get up to the moment information about transactions occurring within the database.

    You can also query sys.dm_os_performance_counters to get the performance monitor counter data within a query.

    "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

  • July 27, 2009 at 8:42 am

    #1030569

    Thanks Grant 🙂

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

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