Wednesday, March 7, 2012

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
After the reindex, queries that benefit from range scans will on clustered
indexes will run faster. What database recovery mode are you using for this
database? After the reindex, your transaction log could be huge.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"srini" <srini@.discussions.microsoft.com> wrote in message
news:4ED82FB1-02C3-4DDF-A2AA-8D12040BDD63@.microsoft.com...
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

No comments:

Post a Comment