Query SQL Server transactions - per day, hour and minute

This post will help you query your SQL Server for transaction count at both the server level and for each of the databases.  The query returns transaction statistics per day, hour and minute since the time of the last service restart.

/* SQL Server transactions per day/hour/minute using sys.dm_os_performance_counters */

       -- declarations

       DECLARE      

              @Days SMALLINT,

              @Hours INT,

              @Minutes BIGINT,

              @LastRestart DATETIME;

       -- get last restart date

       SELECT 

              @Days = DATEDIFF(D, create_date, GETDATE()),@LastRestart = create_date

       FROM   

              sys.databases

       WHERE  

              database_id = 2;

       -- collect days/hours since last restart

       SELECT @Days = CASE WHEN @Days = 0 THEN 1 ELSE @Days END;

       SELECT @Hours = @Days * 24;

       SELECT @Minutes = @Hours * 60;

       -- trans since last restart

       SELECT 

              @LastRestart [LastRestart],

              @@servername [Instance],

              cntr_value [TotalTransSinceLastRestart],

              cntr_value / @Days   [AvgTransPerDay],

              cntr_value / @Hours  [AvgTransPerHour],

              cntr_value / @Minutes [AvgTransPerMinute]

       FROM

              sys.dm_os_performance_counters

       WHERE  

              counter_name = 'Transactions/sec'

              AND instance_name = '_Total';

       -- trans since last restart per database

       SELECT 

              @LastRestart [LastRestart],

              @@servername [Instance],

              instance_name [Database_Name],

              cntr_value [TotalTransSinceLastRestart],

              cntr_value / @Days [AvgTransPerDay],

              cntr_value / @Hours  [AvgTransPerHour],

              cntr_value / @Minutes [AvgTransPerMinute]

       FROM  

              sys.dm_os_performance_counters

       WHERE  

              counter_name = 'Transactions/sec'

              AND instance_name <> '_Total'

       ORDER BY

              cntr_value DESC;

Your output will be similar to this:

Take a look at this for more details on the dm_os_performance_counters DMV:     sys.dm_os_performance_counters