Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

1 Publisher 2 Distributor Expand / Collapse
Author
Message
Posted Wednesday, July 16, 2014 1:39 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 10:07 AM
Points: 61, Visits: 267
Hello,

I recently joined new environment and observe that one of the SQL Server is having Merge Replication Configured on SQL 2005 Instance.

Publisher and Subscriber are configured on instance which is on 2 node cluster.

Distributor is configured on physical server whose hardware configuration is very small (4 GB RAM, etc.).

When there is much load on distributor, there will be performance issues.

With my past experience I know 1 publisher can have only 1 distributer. Does anyone know the possibility of having 2 distributor for 1 publisher?

Also please let me know that distributor on VM is recommended or Physical Server and why?

Thanks in advance,
Post #1593276
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse