Forum Discussion

Copper Contributor

Oct 29, 2019

SQL KQL syntaxt CPU/DTU/DATAI/O help request.

Hello everyone, I' trying to bring CPU avg(90%) of all sql databases, I started with the below kusto but I'm sure that is not correct, I'm new at this and i'm still trying to understand it. cou...

Azure Log Analytics

azure monitor

CliveWatson

Former Employee

Oct 30, 2019

dlaurora

Perf
| where ObjectName =="SQLServer:Databases" and CounterName == "cpu_percent"
| project TimeGenerated, CounterName, CounterValue
| summarize percentiles(CounterValue, 90) by bin(TimeGenerated, 1h) 
| render timechart