Post reply

dbcc dbreindex and transactional replication

  • August 10, 2004 at 7:55 am

    #161866 

    I have transactional replication going.  The database size is about 27 gigs and we purge data every week to keep it around that size. Obviously i want to run dbcc dbredindex after that. What are the performance implications ?Any gothcas ?Regards-srini

  • August 13, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • August 16, 2004 at 3:31 pm

    #519221

    Depends on what your recovery model is. If it it full recovery I'd avoid running dbreindex because the opreation is logged - so you;re looking at 27 Gb transaction log. I'd look through the the indexes to figure out the frgaments indexes and then run defrag them.

     

    HTH

     

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

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