SQL Server MVP Deep Dives

Chapter 37. High-performance transactional replication

Hilary Cotter

The purpose of this chapter is to educate DBAs on how to get maximum performance from their high-performance transactional replication topology across all versions and editions. Most DBAs are concerned with latency—in other words, how old the transactions are when they are applied on the Subscriber.

To set expectations, you should know that the minimum latency of any transactional replication solution will be several seconds (lower limits are between 1 and 2 seconds). Should you need replication solutions which require lower latencies, you should look at products like Golden Gate, which is an IP application that piggybacks off the Log Reader Agent.

Focusing solely on latency ...