Replication process Performance improvements

  • Hi,

    We have transactional replication in our environment. Do we need to update statistics & index maintenance in distribution database to run the cleanup jobs quicker?

  • I would say you should always have index maintenance and statistics update jobs in place, albeit they should be driven by actual fragmentation levels or amounts of changed data, rather than arbitrary choice. If you don't have something already I would look at Ola Hallengren's[/url] or Minion Reindex[/url] by Sean and Jen McCown. Both are excellent. That being said, it's difficult to tell if performance problems are caused by things like out of date statistics or fragmented indexes without more detail.

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

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