Forum Discussion

roopesh_shetty's avatar
roopesh_shetty
Copper Contributor
Dec 03, 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 BitsIn...
Azure Log Analytics
azure monitor
hspinto's avatar
hspinto
Icon for Microsoft rankMicrosoft
Dec 07, 2019

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
Dec 10, 2019

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
    Dec 11, 2019

    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.