x

Maximum Nodes in Replication

Guys,

I know the max number of nodes with SQL clustering but how many nodes can you have with Peer to Peer and Merge replication scenarios with SQL 2008?

Thanks for the help.

more ▼

asked Nov 04, 2009 at 04:43 PM in Default

damon gravatar image

damon
31 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

I was not aware of a hard limit, so I checked MSDN and couldn't find one there either. Obviously, more nodes puts more strain on your infrastructure, so the real limitation will depend on your specific server hardware and network.

For more information ...

Peer-to-peer Replication (Enterprise only): http://msdn.microsoft.com/en-us/library/ms151196.aspx

Merge Replication (Standard or Enterprise): http://msdn.microsoft.com/en-us/library/ms152746.aspx

I also found this limitation for Workgroup Edition, if you are using that:

If an instance of Workgroup is used as a Publisher, it supports a maximum of 25 publications to all merge subscriptions.

more ▼

answered Nov 05, 2009 at 12:19 PM

Tom Staab gravatar image

Tom Staab
5.8k 6 8 10

(comments are locked)
10|1200 characters needed characters left

Plus one for Toms answer. Don't forget the type of system you are running too. Peer-to-peer replication is most suitable for scaling out read operations. Because all writes must be replicated to all nodes in pretty much real time, a highly transaction system can cause load balancing problems. This should have been a comment really, but I can't do them yet.

more ▼

answered Nov 09, 2009 at 10:10 PM

Nige gravatar image

Nige
78 1 1 2

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1850
x306

asked: Nov 04, 2009 at 04:43 PM

Seen: 3128 times

Last Updated: Nov 04, 2009 at 04:49 PM