Cari Blog Ini

16 Juli 2012

Example of Peer-to-Peer Transactional Replication Network Traffic

When deploying peer-to-peer transactional replication,
it is important to understand the network traffic
that is generated between the peers
because this can have a negative impact on your network infrastructure.

Understanding the network traffic and its impact
also allows you to set correct performance expectations for all stakeholders.

Remember that each SQL Server 2005 instance needs to replicate its transactions
to every other SQL Server 2005 instance.

Figure 32-13 shows the network traffic that will be generated
between five SQL Server 2005 instances
in a Peer-to-Peer Transactional Replication topology.


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