x

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

Chitrarekha gravatar image

Chitrarekha
140 32 42 43

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

sp_lock gravatar image

sp_lock
9.2k 24 28 31

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.

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:

x305

asked: Aug 10, 2012 at 08:44 PM

Seen: 1035 times

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