The Publisher database is in use by nearly 300 users with a trafic of about 340trans/sec. After adding replicas with a [strong]push[/strong] subscription (transaction replication with queue mngmt) to 1 subscriber (15 users) the CPU need on the server moved from 25% to about 55% and I can see some collisions between users (through application) and the Distributor itself.
[strong]The question is:[/strong] does it make sense to move the Distribution to a different SQL Instance of the same physical server to remove those bottlenecks and to give at least tha same priority between the users and the distribution agent ? [strong]Or[/strong] is in any case better to move to a Pull subscription instead ?
March 12, 2010 10:49 AM
March 15, 2010 11:11 PM