DECLARE @Batches INT DECLARE @Delay CHAR(8) DECLARE @SecToCalc INT -- set seconds to calculate average SET @SecToCalc = 5 SET @Delay = '00:00:' + CAST(@SecToCalc AS CHAR(2)) SELECT @Batches = cntr_value FROM sys.dm_os_performance_counters WHERE RTRIM(counter_name) = 'Batch Requests/sec' WAITFOR DELAY @Delay SELECT ( cntr_value - @Batches ) / CAST(@SecToCalc AS FLOAT) AS 'Batch Requests/sec' FROM sys.dm_os_performance_counters WHERE RTRIM(counter_name) = 'Batch Requests/sec' GO