dbcc dbreindex and transactional replication

  • 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
  • This was removed by the editor as SPAM

  • 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