http://blog.sqlauthority.com/2010/10/04/sql-server-find-total-number-of-transaction-on-interval/ -- First PASS DECLARE @First INT DECLARE @Second INT SELECT @First = cntr_value FROM sys.dm_os_performance_counters WHERE OBJECT_NAME = 'MSSQL$SQLENT1:Databases' -- Change name of your server AND counter_name = 'Transactions/sec' AND instance_name = '_Total'; -- Following is the delay WAITFOR DELAY '00:01:00' -- Second PASS SELECT @Second = cntr_value FROM sys.dm_os_performance_counters WHERE OBJECT_NAME = 'MSSQL$SQLENT1:Databases' -- Change name of your server AND counter_name = 'Transactions/sec' AND instance_name = '_Total'; SELECT (@Second - @First) 'TotalTransactions' GO
