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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.