Post reply

PAGEIOLATCH_SH

  • September 26, 2003 at 12:20 pm

    #159924

    What does this signify and is having too many spid's with it a serious problem?

  • September 28, 2003 at 4:03 am

    #476101

    Have a look at http://www.sqlmag.com/Forums/messageview.cfm?catid=5&threadid=18898

  • September 28, 2003 at 5:20 am

    #476104

    Pagiolatch_sh is counted when you do physical I/O's from your queries. It depends on what you expect from your queries whether this wait is a problem. If you expect a lot of physical I/O: it's not a problem.

    What is important in this case is wait time: if the average wait time is higher then, say, 10ms, you do have an I/O performance problem. (I use 10ms as an example, but this is maybe a little high if you run against ahigh-end hardware raid disk config)

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

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