By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
439,978 Members | 1,373 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 439,978 IT Pros & Developers. It's quick & easy.

Can Transactional Replication affect Publishing Server?

P: n/a
Here is the architecture for the Transactional Replication:

SERVER1 - PUBLISHER - Also acts as back-end database for
Enterprise-wide application written in VB. Uses ~430 stored
procedures.

SERVER2 - SUBSCRIBER - Also acts as back-end database for Business
Objects.

Replication is set for immediate update.

Sometime earlier this month, a new report was added to Business
Objects which made use of a very large query, with many select
statements. It was expected that this would have a performance hit on
SERVER2.

What was not expected was that it would (appear to) have a performance
hit on SERVER1. One Stored Procedure in particular may grind very
slowly. It may of note that this SPROC addresses the same tables as
the new Business Objects query, albeit on a different server running
on a different box.

Is it possible that running one or more queries on a subscribing
database can have an effect on a publishing database?

NOTE: The servers are on different, dedicated boxes.

If you need any further information, please let me know.

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk
Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.