Forum Discussion

roopesh_shetty's avatar
roopesh_shetty
Copper Contributor
Dec 04, 2019

usage values in percentage

Hi Guys,

We have enabled the Express Route Monitoring using Network Performance Monitor. Using Log Analytics (ERCircuitTotalUtilization) we can get the bandwidth usage of our Express Route in BitsInPerSecond and BitsOutPerSecond value formats. But we wanted to get these values in percentage. Can some one please provide me the OMS query to extract the bandwidth usage values in percentage?

  • roopesh_shetty, I am assuming you want the percentage relative to the ER link bandwidth. For example:

     

    let ERLinkBandwidth = 200000000; // 200 Mbps
    NetworkMonitoring
    | where SubType == 'ERCircuitTotalUtilization'
    | extend BitsInPercentage = todouble(BitsInPerSecond) / todouble(ERLinkBandwidth) * 100
    | summarize avg(BitsInPercentage) by bin(TimeGenerated, 5m), CircuitName
    | render timechart
     
    Is this example close to what you need?
    • roopesh_shetty's avatar
      roopesh_shetty
      Copper Contributor

      thanks, i tried it. But can see the values sometimes above 100% here. If is on percentage then the value should not cross 100 right?

      • hspinto's avatar
        hspinto
        Icon for Microsoft rankMicrosoft

        roopesh_shetty the percentage is relative to ER bandwidth that is set in the ERLinkBandwidth variable. I don't know how much bandwidth you have. Therefore, if you get more than 100% for some records, it means ERLinkBandwidth must be set to a higher value - one that truly represents the bandwidth you have available.

Resources