re: Merge Replication Capacity Planning

Very Impressive Posting — Fri, 11 Feb 2011 23:06:08 GMT

Hi Chris Skorlinski ,

We are looking for the same expert for scaling & Capacity calibration of our production server, we are using Merge Replication with Filter Publications And Datapartions, we are currently facing heavy deadlocks while we implementing the Merge in new subscribers(i.e. Adding new subscribers to the production box). We presently were handling 80 subscribers with 2 hrs sync timing placing across the nation with different time zones.

So we are interested looking forward for your help in scaling our system. Please let me know we are open to talk our MS officer how always helps us in raising the support case with MS.

Please drop me mail or please call me to my number if you are willing to look into this issue. we are willing to raise the support call with MS.

We appreciate your support!!!

My mail id is krishnaj1@michaels.com

Contact # 214 208 8944

Regards

Jayakrishna

re: Merge Replication Capacity Planning

Mike DeLitta — Fri, 21 Jan 2011 00:13:02 GMT

I am running SQL Server 2005 SP3 on a single Windows Server 2003 Enterprise computer running a merge replication single database. It functions as the Publisher and Distributor. We have 65 remote users with push subscriptions. I think we are starting to see a slowdown. The computer is getting old. We have a new computer we want to put into production, but we do not want to decommission the current one - as we do not want to push 65 subscriptions. Do you have any reading we can do that we could somehow (if it is possible) to share the workload between the two computers? Maybe half sync to one and the other half sync to the other. Is is possible to push subscriptions from two different computers for the same database with merge replication?

Thanks in advance.

Mike.DeLitta@AxiomLLC.com