16 Juli 2012

Example of Reading Data Through An Application Server In Peer-to-peer Transactional Replication

Figure 32-11 shows an alternative implementation of peer-to-peer transactional replication
in which an application server is used to load balance DML operations
between two SQL Server 2005 instances.

In this scenario, the data can be read from either SQL Server 2005 instance,
which improves performance.



Source: Microsoft SQL 2005 Administrator's Companion,
Page 1106-1107