Link to home
Start Free TrialLog in
Avatar of Jeffersong
Jeffersong

asked on

Does sql server 2005 replication slow down my initial transaction before it gets sent to the distributor?

I have transactional replication set up between a data center in Mesa, Arizona and a data center in Utah. Mesa acts as the Publisher and Distributor with Utah as the Subscriber.

The initial transaction comes into the database then gets sent to the distributor because it is marked for replication. Does this initial transaction get delayed at all? I am ok with an 8 second delay between Distibutor to Subsciber but an concerned that my initial transaction might be slowed down. I have an SLA of .3 seconds.
ASKER CERTIFIED SOLUTION
Avatar of icemokka
icemokka
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial