May 5, 2017 at 2:58 pm
I need suggestions,tips to improve performance of Transactional Replication.
Every time i have to "re-initialize subscription-> generate new snapshot"; It generates script quickly but stuck for hours to days on bulk insert from distributor to subscriber.
It takes at least 2-3 days to complete.
Is there any way to make it run faster?
Thanks for your help.
May 8, 2017 at 11:26 am
SqlServerLover - Friday, May 5, 2017 2:58 PMI need suggestions,tips to improve performance of Transactional Replication.
- Data is about 132 GB.
- Publisher and distributor are in Europe, both are on same server.
- Subscriber is in USA.
- Network connection between Europe and USA is not too good.
Every time i have to "re-initialize subscription-> generate new snapshot"; It generates script quickly but stuck for hours to days on bulk insert from distributor to subscriber.
It takes at least 2-3 days to complete.
Is there any way to make it run faster?
Thanks for your help.
With a slow network connection, it can be difficult to speed up the re-initalizations.
Make sure you're only replicating the needed columns. Check the publications to make sure articles aren't in multiple publications, If you have large tables in the publications, consider putting them into their own publications to speed up snapshots. In general, look into whether multiple publications might help the re-initalization.
You might also want to look into re-initializing from backups to see if that can improve things as well.
Sue
May 9, 2017 at 10:55 am
I have a question. how often you need to re-initialize? Why u need to re-initialize?
If you really need to re-initialize very often then maybe You can try to use pull subscription and/or using FTP for snapshots.
BartL
Replication Blog
June 29, 2017 at 11:25 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply