SQL Server 2008 - Transaction per second for specific database

Question

Does any one know how to measure the SQL transactions per second for a specifc database in SQL Server 2008?

Answer 1

DECLARE @cntr_value bigint

SELECT @cntr_value = cntr_value
    FROM sys.dm_os_performance_counters
    WHERE counter_name = 'transactions/sec'
        AND object_name = 'SQLServer:Databases'
        AND instance_name = 'YourDatabase'

WAITFOR DELAY '00:00:01'

SELECT cntr_value - @cntr_value
    FROM sys.dm_os_performance_counters
    WHERE counter_name = 'transactions/sec'
        AND object_name = 'SQLServer:Databases'
        AND instance_name = 'YourDatabase'