Avoiding locking/blocking in Replication from multiple locations

Question

In our replication setup; we have data coming to head quarter (transactions of sales etc from multiple manufacturing locations). At times blocking/locking is caused which gets resolved by itself most of time. The default refresh gap is 5 seconds to replicate data say from FACTORY A to head quarter and same from FACTORY B to headquarter. Is there a way to set the refresh gap of say FACTORY B to every 15 seconds to avoid blocking/ locking of transactions when the transactions of FACTORY A are replicating on same table. Will there be any negative effect on performance of replication. Is there any other way to avoid such situation which sometimes gets severe on heavy work load days. Thanks.

Answer 1

Hi @DM

For information about refreshing the Replication Monitor user interface, you can see this link: https://learn.microsoft.com/en-us/sql/relational-databases/replication/monitor/caching-refresh-and-replication-monitor-performance?view=sql-server-ver16#refreshing-the-replication-monitor-user-interface.

Best regards,

Aniya