Transactions Hitting a Database

  • 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

  • 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
    The Scary DBA
    Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Thanks Grant 🙂

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

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