Mismatch in interface utilization data

Hi Team,

I have created a report for Interface utilization. In which other teams have some doubts regarding populated data. Please see the below snapshot FYR.

Q:- The organization is asking, why the Average Transmit BPS Data + Average Receive BPS is not equal to Total Average BPS (Transmit+Receive).

Is there any justification for this mismatch in data? 

Parents
  • That is not how it works

    1. Total Average BPS (Transmit + Receive) = (((Average Transmit BPS) + (Average Receive BPS)) / 2 )

    Which is correct

    2. If I have to quote an example 

    - Say suppose you are polling this information for 25 mins where polling interval is 5 mins each so 5 data points

    - Interface A -  Transmit BPS values - 2,2,2,2,2 - Hence the Average Transmit BPS = 10 (2+2+2+2+2) / 5 = Hence finally value is 2

    - Interface A -  Receive BPS values - 3,3,3,3,3 - Hence the Average Receive BPS = 15 (3+3+3+3+3) / 5 = Hence finally value is 3

    - Total Average BPS = (((Average Transmit BPS) + (Average Receive BPS)) / 2 ) = (2+3)/2 = Hence finally value is 2.5

    - Now lets use the values directly rather than deriving it from (Average Transmit BPS) and (Average Receive BPS) - there are 10 data points in total for - Total Average BPS

    - Total Average BPS = ((2+2+2+2+2) + (3+3+3+3+3)) / 10 -> 5 data points for Transmit and 5 data points for Receive - when you calculate this its 2.5

    Its not sum of  (Average Transmit BPS) + (Average Receive BPS) rather is the Total Average from both Transmit and Receive (both included).

    Hope this helps

  • Hi  

    I hope you're doing well!

    I’m reaching out for some guidance regarding the WAN utilization report I’m working on, as mentioned below.

    I was created a report to present to our organization's management for capacity planning related to WAN utilization. I based this report on the default 95th percentile report but noticed that some of the data doesn’t align. Specifically, the calculation for total bps (Receive Bps + Transmit Bps / 2) doesn’t match the expected values. Even the averages aren't matching as anticipated.

    Could you kindly help me identify what I may have done wrong, or suggest a more suitable report format for WAN utilization related to capacity planning?

    Looking forward to your guidance!

Reply
  • Hi  

    I hope you're doing well!

    I’m reaching out for some guidance regarding the WAN utilization report I’m working on, as mentioned below.

    I was created a report to present to our organization's management for capacity planning related to WAN utilization. I based this report on the default 95th percentile report but noticed that some of the data doesn’t align. Specifically, the calculation for total bps (Receive Bps + Transmit Bps / 2) doesn’t match the expected values. Even the averages aren't matching as anticipated.

    Could you kindly help me identify what I may have done wrong, or suggest a more suitable report format for WAN utilization related to capacity planning?

    Looking forward to your guidance!

Children
No Data