Post reply

Replication Latency due to Selects running on the publisher

  • September 11, 2017 at 6:43 am

    #349114

    Hi Everyone,
    I have a very strange case. We have an OLTP set up with AG and transnational replication. We do around 3K transaction per second when it is not really busy. We have noticed replication latency between Publisher and Distributor when we have long running select queries. Has anyone seen this scenario? Is there anything that can be done about it?

    -Roy

  • September 11, 2017 at 8:59 am

    #1958952

    Enable trace flag 1448. That will help replication configured with AG.

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • September 11, 2017 at 10:13 am

    #1958967

    Thank You. This is the best suggestion I have so far and makes sense. I have been asking it on twitter too and did not get any good suggestion.

    -Roy

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

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