azure - kusto 百分位数转换

Question

我在 KUSTO 上进行了此搜索，但在转换为百分位数时遇到问题。我可以转换为千兆/秒，但不能转换为百分位。当我这样做时，我只获得总数的百分位，而不是每个的百分位。非常感谢任何帮助。

AzureMetrics
             | where ResourceId contains "route"
             | where MetricName == "BitsInPerSecond"
             | where TimeGenerated > (now() - 60m) and TimeGenerated <= now()
             | summarize by Resource, inGigabitPersec=Maximum/100000000
             | summarize percentiles(inGigabitPersec, 100)

谢谢

Answer 1

percentiles() 是一个聚合函数(如 count()、sum())，如果您想为“Resource”的每个值计算它。下一个示例计算每个资源的 P90、P95 和 P100:

AzureMetrics
| where ResourceId contains "route"
| where MetricName == "BitsInPerSecond"
| where TimeGenerated > (now() - 60m) and TimeGenerated <= now()
| extend inGigabitPersec=Maximum/100000000
| summarize percentiles(inGigabitPersec, 90, 95, 100) by Resource