Now calculate 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”.
ChangeRate is taken from Table A-1.
