Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2009-07-16 : 08:49:19
|
| Guys,I have 200GB database which is replicated, the secondary database is subjected to searches (read only) operations. Each day there are up to 500k (up to 200k of them are deletes) transactions that are replicated real time. How should the index maintainence plan be setup since all the transactions are replicated agent, is index rebuild advisable on each night to maintain the reponse times of the searches consistently.Any suggestions and inputs would be hlepThanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-16 : 09:52:27
|
| Depends how long your index rebuild takes, but if you are seeing a lot of fragmentation, you may want to defrag the top 10% or so. Do the full index rebuilds once a week. |
 |
|
|
|
|
|
Replicated Database Index Maintainence