How do you do load and performance testing on SQL Server Merge Replication?

Question

Any ideas on how I can do load and performance testing on SQL Server 2012's merge replciation?

We do replication on millions of records per day. And so we have a requirement to measure how many records it can replicate over a period of time.

As an additional challenge, it will be great if we can simulate having 1000 or more subscribers, and emulate the bandwidth of the subscribers.

This will allow us to measure project proposals even before making changes.

score 0 · Answer 1 · answered Sep 09 '13 at 15:52

The performance will really depend on your network, hardware, and database design. Some guidelines for enhancing general performance are covered in Enhance General Replication Performance. There is also some good tips in Enhance Merge Replication Performance and Merge Replication Performance Tuning and Optimization.

1 Answers1