Tuesday, March 20, 2012

Replication Performance?

I'm having a tough time finding any good resources on Sql Server Replication Performance. Are there any benchmarks / state of any kind? How well does replication scale out?

In my scenario, I have one central publisher and several large tables, all with hundreds of millions of records. Every day I may insert/update millions of records in the publisher, and then I need to replicate the changes (in a few hours at most) onto a pool of subscribers, while they remain online.

Is the replication story robust enough to handle a situation like this?

Is this merge or transactional replication, and on what version lf sql server? And what is the approximate transaction size (meaning how many commands per txn)? Assuming this is transactional replication, performance will depend on your hardware, network bandwidth, size of changes (in K or MB), # of indexes at the subscriber, type of changes (ins, upd or del), existance of triggers, etc.

Throughput of several thousand commands per second is not out of the question, but as I mentioned above, it depends on the above. Tell us more about your scenario and we can comment further. You can reference this basic performance guide, http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx.

No comments:

Post a Comment