Post reply

Batch Requests/sec ; FROM sys.dm_os_performance_counters -how to get SUM /hour?

  • November 22, 2022 at 7:30 pm

    #4116722

    Is it possible to query the SUM(cntr_value) for the previous hour ? (for example, to compare it with Sum of the current hour?) (or any other time period, for that matter?)

    SELECT cntr_value,*

    FROM master.sys.dm_os_performance_counters

    WHERE counter_name='Batch Requests/sec';

    Likes to play Chess

  • November 22, 2022 at 8:06 pm

    #4116735

    as you have been advised on other similar queries you need to implement a storage of these metrics onto a table at a point in time - and then build your reports taking in consideration the point in time values vs the prior point in time.

    and as also advised these counters reset if the instance is restarted (or failed over) so you have the further issue that any restart of server needs to be taken in consideration on your reports.

    or buy something like SQL Monitor that does that for you.

  • November 22, 2022 at 8:30 pm

    #4116741

    Thank you! I'll do just as you advised. Will save the counter value every 1 minute to table.

     

    Likes to play Chess

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply