July 20, 2025 at 5:07 am
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
July 21, 2025 at 5:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
July 21, 2025 at 10:28 pm
I have not used replication before, but quick google brought me to this:
So, I think it depends on where the latency is. Is it between publisher and distributor or distributor and subscriber? And how big is the latency? Replication will always have SOME latency based on how it works, but are you working to fix a few seconds latency or a few hours latency or something in between?
As for how to "fix latency", it depends. It may be due to slow storage or slow network or large transactions or your definition of high latency may be expected latency for your environment. Is the high latency new? If so, what has changed between when it was "good" and when it was bad. If it has always had bad latency, maybe replication isn't the right solution to your problem?
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
July 22, 2025 at 10:18 am
As already stated, need more detail on the latency length and how the publisher, subscriber and distributor are configured.
The replication monitor usually provides good info on the current state
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2025 at 6:35 pm
Latency is about 20 minutes. I already checked slow storage or slow network or large transactions and they all are good.
July 22, 2025 at 10:17 pm
is that 20 minute latency from publisher to distributor or distributor to subscriber?
If it is publisher to distributor, then how many transactions are waiting to distribute and how fast is the distributor distributing them?
And did you read that article I linked?
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
July 23, 2025 at 2:23 pm
Latency is between distributor and subscriber.
July 23, 2025 at 3:16 pm
How many transactions are waiting to distribute and how fast is the distributer distributing them?
And did you read the article I linked? If you scroll down to the section "Improving the Latency Between Distributor And Subscriber", it provides multiple suggestions on how to reduce latency between the distributor and subscriber...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply