Post reply

PAGEIOLATCHES

  • February 7, 2012 at 6:56 am

    #264049

    We had some issues last with our SAN. Even though the databases are now back on-line we are experiencing IO issues (I believe) and the PAGEIOLATCH counts seem high to me:

    wait_typewaiting_tasks_countwait_time_mssignal_wait_time_msio_wait_time_ms

    PAGEIOLATCH_EX5107615435303361543194

    PAGEIOLATCH_SH11138120482024992047703

    PAGEIOLATCH_UP4972294794229475

    Do these seem high?

    Thanks

    Steve

  • February 7, 2012 at 7:08 am

    #1443751

    No way to answer that.

    Those counters are cumulative since SQL started. If the server started last an hour ago, yeah they're high, if the server started 3 days ago, no so much.

    A single view of sys.dm_os_wait_stats is pretty useless, to get any real meaning you want to check twice a certain time apart and see how the values have changed and consider that.

    Also check and see if you have individual queries with high pageIOLatch waits and check the disk latencies in perfmon (avg sec/read and avg sec/write)

    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

  • February 7, 2012 at 7:11 am

    #1443753

    Yes it was 3 hours ago.

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

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