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 ?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!