Post reply

Page Reads/sec is a very high number

  • November 11, 2009 at 5:37 pm

    #213949

    I have an SQL Server 2005 machine which is currently not doing all that much. There is hardly any CPU Usage, network io and physical io.

    However, when I run the following command on the machine,

    select object_name, counter_name, cntr_value

    from sys.dm_os_performance_counters

    where counter_name = 'Page reads/sec'

    I get the following

    object_name counter_name cntr_value

    ------------------------- -------------- --------------------

    SQLServer:Buffer Manager Page reads/sec 3294081839

    Can anyone tell me why this is so high?

  • November 12, 2009 at 2:41 am

    #1078213

    From books online:

    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

  • November 12, 2009 at 2:09 pm

    #1078599

    Thanks for that reply.

    Overlooked that on the books.

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

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