Subscribe to this blog
Chris Jenkins' Blog
I’m a Senior Database Developer with Innovise IES in Southampton, UK. I’ve been working with SQL Server since 2003 and have worked with all editions since SQL Server 2000. I design, develop, administer, and tune SQL Server relational and OLAP solutions.
I’m a Microsoft certified technology specialist in SQL Server 2008 Database development.
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
0 comments, 363 reads
Posted in Chris Jenkins' Blog on 26 November 2012
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.
Symptoms:
- Your distribution database is growing quite large
- The distribution cleanup job is taking a long time to run, yet not clearing as…
0 comments, 223 reads
Posted in Chris Jenkins' Blog on 8 November 2012