O'Reilly logo

SQL Server MVP Deep Dives by Greg Low, Paul Randal, Kimberly Tripp, Adam Machanic, Kalen Delaney, Paul Nielsen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required