Post reply

dbcc shrink file waiting for PAGEIOLATCH_SH

  • June 3, 2010 at 10:25 am

    #233326

    SQL server 2005 Enterprise Edition SP2

    Database size ~ 300 gig

    ---- shrinking by 50 gig approx

    Doing

    DBCC SHRINFILE(Test_Data,256000)

    It keeps running for almost 12 hours , spid suspended and waittype showing for it is PAGEIOLATCH_SH

    Anyone same scenario and resolve the issue?

  • June 3, 2010 at 1:58 pm

    #1176166

    Why are you shrinking in the first place? Can you be absolutely sure that space will never be used again? If not, then there really is no reason to shrink at all.

    Besides, once you are done with this shrinking - then you would have to rebuild all of your indexes to recover from the fragmentation that was introduced with the shrink.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

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

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