Bandwidth comparison between log shipping and transactional replication Which technique uses more network bandwidth:


Log shipping
Transactional Replication


Can some one share any benchmarks for the same ?

What would be the Memory and I/O impact on the Primary server when we use any one of the technique ?

Thanks,

Piyush Patel
It depends on your workload.  As a baseline, use Performance Monitor and log the network counters when not using Log Shipping or Transactional Replication and measure for 1 hour.  Then setup Log Shipping and use Performance Monitor to log the network counters for 1 hour.  Then setup Transactional Replication and use Peformance Monitor to log the network counters for 1 hour.  The network bandwidth that Log Shipping and Transactional Replication consumes is the difference between the collections and the baseline.  The same can be done for memory and I/O.