I am about to apply DBCC DBREINDEX to a large database that is part of transactional replication and synchronised every 3 minutes. What are the likely implication and what precautions I must take.
Thanks in advance
Regards
R Suresh
Logreader will not replicate the index rebuild operation. Also if you use SQL 2005, I recommend you to use ALTER INDEX to rebuild index because DBCC DBREINDEX is a deprecated feature.
Of course, you need to do some experiment to see the performance impact if you do it frequently.
Peng
No comments:
Post a Comment