• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

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.
1 Solution
If it's one way replication, you should really consider async Mirroring.
This is not 100% transactional put keeping a transaction open over a slow WAN is asking for troubles.

But I tend to see a better performance with Mirroring then with replication.
It's also less fragile and easier to setup & maintain.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now