Moving Distribution database from an instance to antother does increase performance ?

5 pts.
Tags:
distrib.exe
Performance/Tuning
SQL Server 2005
SQL Server Performance Monitoring
transaction replication
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 ?



Software/Hardware used:
SQL2005

Answer Wiki

Thanks. We'll let you know when a new response is added.

best to move the distribution to a sql server instance on another physical machine

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following