Forum Discussion
roopesh_shetty
Dec 04, 2019Copper Contributor
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?
- hspinto
Microsoft
roopesh_shetty, I am assuming you want the percentage relative to the ER link bandwidth. For example:
let ERLinkBandwidth = 200000000; // 200 MbpsNetworkMonitoring| where SubType == 'ERCircuitTotalUtilization'| extend BitsInPercentage = todouble(BitsInPerSecond) / todouble(ERLinkBandwidth) * 100| summarize avg(BitsInPercentage) by bin(TimeGenerated, 5m), CircuitName| render timechartIs this example close to what you need?- roopesh_shettyCopper 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
Microsoft
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.