Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Replication performance

Author  Topic 

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2011-06-19 : 16:26:55
I have some data that needs to be sent to two other servers. I want to use replication.

In terms of performance is it better to have one publication with two subscriptions. Or is it better to have two publications with one subscriber each?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-06-19 : 16:42:59
Use one publication with two subscriptions that way you don't have to send the data to the distributor twice.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -