Replication Latency due to Selects running on the publisher

  • 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?


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

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

  • 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.


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

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