July 27, 2017 at 8:28 am
Hi,
I have Merge replication working, It is merging several databases between the server. I observed on one database the merge replication is very slow it looks like it is taking time to upload changes to publisher, While downloading changed from publisher is working without any issues.
for example you can see the attached excel log file, the slow db is taking about 6 minutes to upload the changes, where as the other one communicates with out any issues. This database is heavily used at the publisher site, little use at the subscriber side, although the problem here is uploading data from subscriber(Little used) to publisher(Heavily used) the other way is working without any issues.
Any help appreciated on how to troubleshoot this.
Thanks.
July 31, 2017 at 3:36 pm
A couple of things to check -
Do you see any blocking going on in the Publisher that could be slowing things down?
You might also want to test out the connections to see if the something in the network is slowing things down. A basic test would be to copy a file from slow subscriber to publisher and the other way from publisher to slow subscriber.
Sue
August 2, 2017 at 3:54 am
Hi Sue,
Thanks for the update. I don't really see any blocking with the things going upwards, The other databases in the replication are working normally. As far as I can test the connections are good as well. Even when there is no updates to send to publisher it is taking a long to check and then just reporting no changes to upload.
I am not that gives you any more clues to point me...?
Thanks for your update.
Regards,
Ashok
August 2, 2017 at 11:02 am
ashok_p - Wednesday, August 2, 2017 3:54 AMHi Sue,Thanks for the update. I don't really see any blocking with the things going upwards, The other databases in the replication are working normally. As far as I can test the connections are good as well. Even when there is no updates to send to publisher it is taking a long to check and then just reporting no changes to upload.
I am not that gives you any more clues to point me...?
Thanks for your update.
Regards,
Ashok
It can be so many different things. A lot of the times I've seen it be an issue with indexes and stats needing updates but that's not always the case.
You can try going through all the tips in these articles - it's a few dozen or more:
Performance Tuning Merge Replication
SQL Server 2014 Merge Replication Optimization Tips (Part 1)
SQL Server 2014 Merge Replication Optimization Tips (Part 2)
Sue
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply