• Jeff Moden (12/9/2012)


    GilaMonster (12/9/2012)


    No.

    Page reads != fragmentation.

    Do you consider page splits to be a form of fragmentation?

    Page splits may cause logical fragmentation (or may not, depending which pages split).

    Memory\Page reads/sec (the perfmon counter) is pages (windows memory pages) read into memory from disk because they're referenced in virtual memory but not present in physical memory, ie hard page faults, and isn't even a SQL specific counter. Probably SQL is either being swapped to the page file because there's other stuff on the server using memory or something else on the server is being swapped to the page file

    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