Create distribution database

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.

more ▼

asked Aug 10, 2012 at 08:44 PM in Default

avatar image

140 37 42 45

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?

Aug 13, 2012 at 02:35 PM Chitrarekha
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Aug 11, 2012 at 02:46 PM

avatar image

10.9k 27 37 37

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, 2012 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, 2012 at 06:50 PM sp_lock
(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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Aug 10, 2012 at 08:44 PM

Seen: 1350 times

Last Updated: Aug 16, 2012 at 06:41 AM

Copyright 2018 Redgate Software. Privacy Policy