Tag

SQL Server Replication

Reducing the size of the distribution database & improving transactional replication performance: Part 3

Date: 20th October 2014
Author: Chris Jenkins
Category: Replication Performance Tuning

The final (and much delayed) part of this series focuses on the choice between replicating stored procedure calls and replicating the data modified by stored procedure calls.

Reducing the size of the distribution database & improving transactional replication performance: Part 2

Date: 26th November 2012
Author: Chris Jenkins
Category: Replication Performance Tuning

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 to a minimum.

Reducing the size of the distribution database & improving transactional replication performance: Part 1

Date: 8th November 2012
Author: Chris Jenkins
Category: Replication Performance Tuning

In this series of blog posts, I will be 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 much data as you would expect.