December 17, 2008 at 9:19 am
HI GUYS,
In sql 2005 replication how many subscribers can we add in a publication?, or is it any number?, how each subscriber affect the performance?
Thanks
December 18, 2008 at 5:35 am
You can have any number of subscribers as far as I am aware. However, you're correct to think about performance implications as each replication agent has an overhead which I can't remember off the top of my head. My replication structure is different from yours by the sound of it in that we have a large number of publishers and a small number of subscribers. We have 1650 distribution agents spread across 9 distributors. We run publishers, distributors and subscribers on their own servers.
Your limiting factor will be how many distribution agents your distributor can handle. Our distribution servers are low-ish spec (4 cpu 4GB ram, though 2 are 4 cpu dual core I think) and one of them supports 218 of the 1650 distribution agents.
Hope that helps in some way.
December 18, 2008 at 9:23 am
Be aware that since distribution agents each run in their own process you run the risk of running out of non-interactive desktop heap. There are two ways around the problem: 1) Run your agents on non-overlapping schedules, or 2) if you run your agents continuously you can bump up the size of the non-interactive desktop heap with a registry edit.
Read my blog post about this for more information: http://kendalvandyke.blogspot.com/2008/06/when-good-replication-agents-go-bad.html
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply