How to fix transactional replication latency

Question

How to fix transactional replication latency

Chaitanya Kiran 801

Good Morning All,

We are facing replication latency issue. I checked for blocking, long running transactions or bulk operations running. I tried re-running the distribution agent job also. But still the latency exists. Could you please tell me what all I need to do to fix the latency

Thanks,

Chaitanya

Ben Miller-(DBADuck) 195 Reputation points MVP

2025-07-29T14:41:45.12+00:00

Replication latency is a broad topic. Latency in what fashion? What is your link between the replicas? Where is the distributor? Is it a Pull subscription or Push?
Chaitanya Kiran 801 Reputation points

2025-07-30T07:36:45.05+00:00

Latency is about 20 minutes between distributor and subscriber. I already checked slow storage or slow network or large transactions and they all are good. It is a Push subscription.

1 answer

Your answer

Ben Miller-(DBADuck) 195 Reputation points MVP

2025-07-29T14:41:45.12+00:00

Replication latency is a broad topic. Latency in what fashion? What is your link between the replicas? Where is the distributor? Is it a Pull subscription or Push?
Chaitanya Kiran 801 Reputation points

2025-07-30T07:36:45.05+00:00

Latency is about 20 minutes between distributor and subscriber. I already checked slow storage or slow network or large transactions and they all are good. It is a Push subscription.

Answer 1

To improve the replication latency you can try the following options

You can create custom profile with large number of batch size (-CommitBatchSize, -BcpBatchSize and -CommitBatchThreshold)
https://learn.microsoft.com/en-us/sql/relational-databases/replication/agents/work-with-replication-agent-profiles?view=sql-server-ver17
Add additional subscription streams on the distribution agent
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/configure-troubleshoot-subscriptionstreamsof-distribution-agent

Share via

How to fix transactional replication latency

1 answer

Your answer