Now calculate the OutboundQueueVolume for tables T1, T2, and T3. Because selectivity is measured on a table basis (rather than a database basis), you must calculate outbound queue size for each table replicated through it. The formula for calculating the maximum OutboundQueueVolume is:
OutboundQueueVolume = sum(OutboundTableVolume * ReplicationSelectivity) + OutboundTransactionVolume
where:
OutboundTableVolume is taken from the calculations performed in “Calculating table volume”.
ReplicationSelectivity values are from Table A-2: “Site parameters—table replication selectivity”.
TransactionVolume is the size of the Messagebegin and Messagecommit pairs (250 bytes + 200 bytes) times the TransactionRate.
The formula for calculating the OutboundQueueVolume for Site 1 is:
OutboundQueueVolumeS1 = OutboundTransactionVolume + (TableVolumeT1*ReplicationSelectivityT1,S1) + (TableVolumeT2*ReplicationSelectivityT2,S1) + (TableVolumeT3*ReplicationSelectivityT3,S1)
The OutboundQueueVolumes for the three sites are:
Site1 = (450*5) + (10K/sec*0.1) + (8K/sec*0.4) + (5K/sec*0.2) = 7K/sec
Site2 = (450*10) + (10K/sec*0.4) + (8K/sec*0.8) + (5K/sec*0) = 15K/sec
Site3 = (450*8) + (10K/sec*0.4) + (8K/sec*0) + (5K/sec*0.2) = 9K/sec
