Does sql server 2005 replication slow down my initial transaction before it gets sent to the distributor?
Posted on 2009-04-20
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.