SQL Server 2008 - transaction per second for a specific database

Question

Does anyone know how to measure SQL transactions per second for a specificc 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' 

Answer 2

The sp_BlitzFirst procedures located at https://www.brentozar.com/askbrent/ return this information at the database level, as well as many other useful information. A simple call, as shown below, will show you what happens in 5 seconds.

 EXEC dbo.sp_BlitzFirst @ExpertMode = 1, @seconds = 5;