Calculating Table Volume

The volume of data being replicated is the size of each message times the number of messages replicated per second.

• Table Volume Upper Bound Method
  Calculate table volumes and database volumes for inbound and outbound queues separately. Or, calculate the volume only for outbound queues and use that figure as an approximation for both inbound and outbound volumes.
• Table Volume Sum of Values Method
  Obtain a precise calculation of data volume by adding together all of the volumes for each message type.
• Transaction Volume
  TransactionVolume estimates data volume generated by the begin and commit records.
• Database Volume
  Calculate a rough estimate of the upper limit of database volume by adding together the upper bound message rates for each table.
• Inbound Queue Size
  An inbound queue contains updates to all of the replicated tables in a primary database. The inbound queue keeps these updates for the duration of the longest open transaction. Queue sizes are expressed in bytes.
• Outbound Queue Volume
  An outbound queue sends data to another Replication Server or to a data server. In these calculations the destination is called a direct destination site.
• Failure Duration
  If the direct destination site is unavailable, the queue buffers its messages. The failure duration figure you use to establish queue size determines how long a failure the queue can withstand.
• Save Interval
  The save interval specifies how long data is kept in outbound queues before it is deleted. The save interval helps in recovering from a disk or node loss.
• Outbound Queue Size
  Calculate the outbound queue size.