|
Is the distribution database always created where the publication database is created. I have about 13 databases on the server and they will be replicated using snapshot replication.
(comments are locked)
|
|
The distribution can be created on a different server to potentially reduce to over-head at the publisher. Currently I have 18 DBs that use the same distribution DB (hosted on the same SQL instance), but it does have its own data/log array. I think the detail of your answer is the key - the Distribution database needs to be configured for high performance if it is likely to be crucial to an environment that is busy. It will work on the same instance or a different one but can perform badly in either if the settings are not considered and configured to be optimal
Aug 12 '12 at 05:45 PM
Fatherjack ♦♦
Its always hard to comment with limited info. It could be 13 replicated DBs on FusionIO cards. But MS do suggest sep arrays for performance.
Aug 12 '12 at 06:50 PM
sp_lock
(comments are locked)
|
I am using the following link to setup transactional replication. http://www.sql-server-performance.com/2010/transactional-replication-2008-r2/3/. I have sqlserver 2008r2 on a sqlserver 2008 server. Do I use the distribution database on server A, Publication database on Server B and connect to Server C for the subscriber database?