some LinkedServer + some replication vs Lot of Linked server and very few replications
Posted on 2013-01-11
which is better, performance wise:
one main server replicating to 3 next level servers.
then 5 servers have linked server connection to each of the above 3 servers.
so the first 3 get their supply for data from main server through continuous replication. then the remaining 15 get access through linked servers to the 3 servers.
18 servers hit the main server through linked server.
(they are all the same database in the 19 servers). as the main server is updated, local copy is needed in 18 servers.. that is the plan..
which do you think is reasonable and more efficient in all seasons.. (in general standards recommendation)