Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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 3

Part 1 of this series of articles looked at the intricacies of SQL Server transactional replication, and made the observation that the clean-up mechanism treats publications as a collective.  Part 2 looked at how differing distribution job schedules can cause unnecessary bloating in the distribution database.

The final (and much… Read more

2 comments, 5,585 reads

Posted in Chris Jenkins' Blog on 20 October 2014

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

4 comments, 1,326 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…

Read more

0 comments, 2,258 reads

Posted in Chris Jenkins' Blog on 8 November 2012