How to fix transactional replication latency

Question

How to fix transactional replication latency

Chaitanya Kiran 841

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) 280 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 841 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.
Anonymous

2025-12-02T04:10:01.2733333+00:00

Hi @Chaitanya Kiran ,

Could you please let us know if the issue has been resolved? I wanted to check if you had the opportunity to review the information provided by @Kumarasamy, Selvaputthiran . If you still require support, please let us know, we are happy to assist you.

Thank you

Answer recommended by moderator

0 additional answers

Your answer

Ben Miller-(DBADuck) 280 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 841 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.
Anonymous

2025-12-02T04:10:01.2733333+00:00

Hi @Chaitanya Kiran ,

Could you please let us know if the issue has been resolved? I wanted to check if you had the opportunity to review the information provided by @Kumarasamy, Selvaputthiran . If you still require support, please let us know, we are happy to assist you.

Thank you

Answer 1

Kumarasamy, Selvaputthiran 0

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

0 comments

Share via

How to fix transactional replication latency

0 additional answers

Your answer