Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Angry Unanswered: update is hangging; PAGEIOLATCH_SH

    This update used to take 30 minutes. Now it's taking 4 hrs and hanging.
    There is intense disk IO with no memory use. I see a wait for a resource with a wait-type of PAGEIOLATH_SH

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Re: update is hangging; PAGEIOLATCH_SH

    RE:
    This update used to take 30 minutes. Now it's taking 4 hrs and hanging.
    There is intense disk IO with no memory use. I see a wait for a resource with a wait-type of PAGEIOLATH_SH
    Seeing intense disk IO makes sense, PageIOLatch generally refers to an I/O wait relating to reading a page. You may wish to consider checking for disk issues e.g.(RAID in FT mode), or for unrelated heavy disk I/O of some kind in progress.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •