June 22, 2010 at 12:29 pm
Hi everyone,
I've been googling for an answer to my question, but haven't found anything of use. For those of you who have set up replication, how is the speed of this technology? For example, if on server A, 20 million records are updated, how long will it take for those changes to be applied to server B that resides on the same network? Thank you.
June 22, 2010 at 2:08 pm
We replicate a table that has roughly 13 million records. However, we do transactional replication to 2 different subscribers. Works like a charm and doesn't take overly long. Of course this depends on what else you're replicating and to where...
June 22, 2010 at 2:50 pm
Hi, thanks for your response. We have a 300GB database that we want to replicate, with all the objects in it. There are a ton of updates that happen during the day to this database. I was wondering, how long will it take SQL Server to apply 20 million changes to the replicated server in a merge replication setup?
June 22, 2010 at 2:54 pm
There's only 1 true way to know! There are so many factors regarding "speed" that I would suggest trying something this large in your own test environment.
June 23, 2010 at 10:34 am
Good point! Thx.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply