Post reply

Help required regarding Batche Requests/sec

  • March 2, 2017 at 12:29 am

    #335419

    Hi Folks,

    When I look at Batch Requests/sec in the Activity Monitor I see a dynamic figure that changes when the Count changes.

    When I run the following query


    SELECT *
    FROM sys.dm_os_performance_counters
    where counter_name in ('Batch Requests/sec') 
    or counter_name like ('SQL %Compil%');

    I get what appears to be an incrementing number.

    Can someone please explain why that is?

    Regards,
    Kev

  • March 2, 2017 at 3:56 am

    #1931131

    https://blogs.msdn.microsoft.com/psssql/2013/09/23/interpreting-the-counter-values-from-sys-dm_os_performance_counters/

    cntr_value

    Current value of the counter.
    Note 

    For per-second counters, this value is cumulative. The rate value must be calculated by sampling the value at discrete time intervals.
    The difference between any two successive sample values is equal to the rate for the time interval used.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 2, 2017 at 4:00 am

    #1931132

    Thanks Gail......it explains alot....

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

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