Table Volume Example Calculations

Calculates the table volumes for tables T1, T2, and T3.

For simplicity, what is presented here is a worst-case analysis that assumes all changes are due to SQL update statements plus their associated begin/commit pairs.

Using the upper bound formula for InboundTableVolume:

InboundTableVolume = (Max[InboundMsgSize]*ChangeRate)

The inbound table volumes for tables T1, T2, and T3 are:

InboundTableVolumeT1 = 1130*20 = 23K/sec

InboundTableVolumeT2 = 1430*10 = 14K/sec

InboundTableVolumeT3 = 9480*2 = 19K/sec

Using the upper bound formula for OutboundTableVolume:

OutboundTableVolume = (Max[OutboundMsgSize]* ChangeRate)

The outbound table volumes for tables T1, T2, and T3 are:

OutboundTableVolumeT1 = 524*20 = 10K/sec

OutboundTableVolumeT2 = 816*10 = 8K/sec

OutboundTableVolumeT3 = 2716*2 = 5K/sec

where:

InboundMsgSize and OutboundMsgSize are taken from the calculations performed in Table Update Calculations topic.
ChangeRate is taken from the Table parameters .