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.

Archives: November 2012

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, 1,091 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, 1,729 reads

Posted in Chris Jenkins' Blog on 8 November 2012