Reducing the size of the distribution database & improving transactional replication performance: Part 2
The impact of having data sitting in the distribution database that doesn’t need to be there can be significant. The aim of this series of articles is show you how to keep the distribution database as small (and efficient) as possible, and to keep the impact of the clean-up job… Read more
Reducing the size of the distribution database & improving transactional replication performance: Part 1
In this series of blog posts I will looking at issues regarding the size and performance of the distribution database as part of a transactional replication environment.
- Your distribution database is growing quite large
- The distribution cleanup job is taking a long time to run, yet not clearing as…