Post reply

PAGEIOLATCH_SH and memory

  • August 7, 2008 at 6:06 pm

    #75276

    Greetings,

    On running an update to a million + rows I'm seeing a wait type of PAGEIOLATCH_SH. From what I understand, this is usually related to memory pressure, but when I run PerfMon my Pages/sec counter is very flat, actually at zero, with only occassional and breif spikes. Should I be using a different object in the Memory category or is this unrelated?

    Thanks,

    Tim

  • August 8, 2008 at 1:56 am

    #854960

    PageIOLatches often indicate slow disks. Try the following counters

    Physical Disk avg sec/read

    Physical Disk avg sec/write

    Physical Disk % idle time

    SQL Buffer manager checkpoint pages/sec

    SQL Buffer manager lazy writes/sec

    Pages/sec just gets you page faults (page not in real memory, look in swap file). There should be no page swapping on a well running SQL box

    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

  • August 8, 2008 at 9:03 am

    #855283

    Thanks, I think I got some of my readings mixed up there. Thank you for straightening me out. The update also turned out to be 10 + million row, but what's a factor of 10 among friends 😀

    Tim

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

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