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