sql server replication: Distribution Clean Up Agent - Frequency -- sql server replication

Distribution Clean Up Agent - Frequency

KP
11/6/2003 7:00:34 AM

sql server replication:

Hi

I have about 8 transactional publications, each of which
has one subscriber (I have only one subcscriber, who
subscribes to the all 8 pubs). Each subscriber
replicates once a day, everyday at the same time.

My question is: Can I set the Distribution Clean Up
Agent to run once a day, after the replication has taken
place? Will this grind my server to a halt?

Right now the Distribution Clean Up Agent runs every ten
minutes, sometimes for 5-6 minutes at a time, and
negatively impacts my SQL Server performance. Any

Re: Distribution Clean Up Agent - Frequency

Hilary Cotter
11/6/2003 9:24:17 PM

You can set your distribution clean up agent to any schedule you want. Some
people will set it to a daily schedule so they can roll back and forth in
their distribution schedule. In other words if their subscriber goes south,
they can restore the early morning version of it, and the distribution
commands will fill in to make the subscriber current.

However your msrepl_transactions and msrepl_commands tables can grow large
depending on the number of transactions on your publisher, and performance
may be degraded as you have seen.

[quoted text, click to view]