Post reply

Readahead Pages/Sec

  • March 6, 2008 at 6:36 am

    #785902

    What does your full scans/sec look like?

    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 6, 2008 at 10:09 am

    #187552

    How to reduce Readahead Pages/Sec?

  • March 6, 2008 at 12:01 pm

    #786269

    Check the full scans/sec counter.

    From what I know, read-ahead reads are usually done when a table or index is scanned, and the storage engine fetches pages before they are requested, on the assumption that they will be needed.

    What's the value of your Readahead Pages/Sec? How big is the DB? How active?

    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 6, 2008 at 12:25 pm

    #786284

    Thanks Gail Shaw,

    The value of Readahead Pages/Sec is going above 2,000.

    There are 50 DBs of different size. Max 30 GB

    Not very active in the night. During non business hours also Readahead Pages/Sec goes above 2,000.

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

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