Post reply

Re-index large table 24hr system

  • March 17, 2008 at 7:23 am

    #76927

    I am not sure there is a soultion but i have 10 reindexes which will take over an hour to run and the worst ones taking many hours to run. All these table are critical so can not be locked. This system is a 24hr system.

    I guess the only way to reindex is to have scheduled down time. Or upgrade to 2005.

    Any other ideas?

    Thanks

  • March 17, 2008 at 7:28 am

    #790327

    You can use DBCC INDEXDEFRAG. I'm sure there will be some type of performance hit but you can run this while the application is in use.

    -- You can't be late until you show up.

  • March 17, 2008 at 8:52 am

    #790393

    tosscrosby (3/17/2008)

    You can use DBCC INDEXDEFRAG. I'm sure there will be some type of performance hit but you can run this while the application is in use.

    Toss, is right. DBCC INDEXDEFRAG will not lock table but I find DBCC INDEXDEFRAG too slow if its a large table and after it get succeeds you might have to execute update statistics TABLENAME will fullscan to get the best results.

    SQL DBA.

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

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