Forum Discussion

Microsoft

Apr 04, 2018

Use percentiles function on Azure Metrics

Hello, I am trying to modify this default query to give me the percentiles of DTU usage for my Azure SQL Database. Any idea how I can go about that? AzureMetrics | where ResourceProvider...

azure monitor

Query Language

Noa Kuperberg

Microsoft

Apr 08, 2018

Hey Larissa,

try this query, it calculates percentiles of the "Maximum" value:

AzureMetrics
| where ResourceProvider=="MICROSOFT.SQL"
| where MetricName=='dtu_consumption_percent'
| summarize percentiles(Maximum, 25, 50, 75, 99) by bin(TimeGenerated, time(14m))
| sort by TimeGenerated desc
| render timechart

HTH,

Noa