[Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2009-04-20
Medium Priority
Last Modified: 2012-05-06
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.
Question by:Jeffersong
1 Comment

Accepted Solution

icemokka earned 2000 total points
ID: 24191646
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.

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question