Replication: Transactional Replication Over WAN

Replication: Transactional Replication Over WAN

  • Comments 1
  • Likes

A lot of users have wondered about the performance latency transactional replication suffers over WAN.

After analyzing / discussing this within the teams, here are the main points one should take into consideration when deciding / testing this type of implementation:

Should you notice performance degradation when testing your transactional replication over WAN, please verify the following:

1. Where is the latency occurring? Could it be an issue on the publisher / subscriber (example:blocking)

2. Verify that the @status of the articles published have the value of 16 or 24. Please see previous post in regards to this in order to understand the reason for performance benefit.

3. Disable offload TCP Checksum

    http://msdn.microsoft.com/en-us/library/aa938424.aspx

4. Disable TCP Chimney

    http://blogs.msdn.com/psssql/archive/2008/10/01/windows-scalable-networking-pack-possible-performance-and-concurrency-impacts-to-sql-server-workloads.aspx

5. Use a PULL subscription instead of a PUSH

6. Should the above 5 options not help in the performance, I would highly recommend the following:

    Geo-Replication Performance Gains with Microsoft SQL Server 2008 Running on Windows Server 2008

    http://technet.microsoft.com/en-us/library/dd263442.aspx

Comments
  • There is a product called NitroAccelerator (nitrosphere.com) that speeds replication over the WAN by 80-90%.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment