Post reply

Perfmon: SS Buffer Mgr: Page Reads/sec and Page Writes/sec

  • September 15, 2008 at 6:31 am

    #198150

    Hi,

    According to my research these two counters represent the number of physical db page reads/writes issued per second and they should be less than 80 on a normal system. Above that indicates there could be a problem with indexes or the server memory is under pressure.

    So far, fine.

    However, when I add these two indexes to perfmon on their own, at default settings, I have a scale of 1 to 100 and their scale setting is 0.01, so you can hardly see them.

    If I change the scale of the counters to 1.0, then I can see them plotting values between 0 and 100.

    So am I now doing this right and if I see them go above 80 I could have a problem?

    Thanks,

    Richard

  • September 15, 2008 at 11:48 am

    #871961

    All these numbers are really tied to the hardware capacity unless they are expressed in "%" .

    You should check for "hard" numbers AFTER you have established a base line.


    * Noel

  • September 17, 2008 at 12:47 pm

    #873208

    I'm interested in where the figure of 80 came from? a hit ratio I can follow but a counter of reads would be hardware specific. I have a sql2k box which does millions of page lookups/sec - would be keen to know where the 80 came from.

    could I refer you to my web site for some counter advice from the ms SQLCAT team.

    http://www.grumpyolddba.co.uk/monitoring/Performance%20Counter%20Guidance%20-%20SQL%20Server.htm

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • September 17, 2008 at 1:32 pm

    #873238

    colin Leversuch-Roberts (9/17/2008)

    I'm interested in where the figure of 80 came from? a hit ratio I can follow but a counter of reads would be hardware specific. I have a sql2k box which does millions of page lookups/sec - would be keen to know where the 80 came from.

    could I refer you to my web site for some counter advice from the ms SQLCAT team.

    http://www.grumpyolddba.co.uk/monitoring/Performance%20Counter%20Guidance%20-%20SQL%20Server.htm

    Sorry the "80" figure came from a webcast my an MPV, and I didn't keep a reference to it, so no idea who it was. Thanks for the link to your counter advice. 🙂

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

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