Post reply

latency replication

  • January 18, 2018 at 5:54 am

    #402846

    Hello
    I configured a transactional replication system in my production environment
    On some databases I have transaction transfer delay between the distributuion server and the subscriber
    What are the best practices to improve the perfermence
    thank you for your help

  • January 18, 2018 at 7:44 am

    #1976325

    joujousagem2006 1602 - Thursday, January 18, 2018 5:54 AM

    Hello
    I configured a transactional replication system in my production environment
    On some databases I have transaction transfer delay between the distributuion server and the subscriber
    What are the best practices to improve the perfermence
    thank you for your help

    There are quite a few articles, blogs and such that discuss some things for tuning replication. What works for you is really going to depend on things such as how things are configured in your environment, the volume of transactions, etc. Some articles that might help -
    Enhance Transactional Replication Performance
    Performance Tuning SQL Server Transactional Replication: A Checklist

    The Microsoft blog REPLTalk has a lot of great tips - you may need to do a bit of digging to find specifics for your situation but it's a good site to know about and read when you administer replication:
    REPLTalk covers Using and Tuning SQL Replication

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply