Oct 29 2019
10:00 AM
- last edited on
Apr 08 2022
10:10 AM
by
TechCommunityAP
Oct 29 2019
10:00 AM
- last edited on
Apr 08 2022
10:10 AM
by
TechCommunityAP
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. could anyone help me with this?
I also have to do the same with DTUs and data I/O, but if you could help me with only one I may be able to get the rest
Thanks.
Oct 30 2019 06:23 AM
Perf
| where ObjectName =="SQLServer:Databases" and CounterName == "cpu_percent"
| project TimeGenerated, CounterName, CounterValue
| summarize percentiles(CounterValue, 90) by bin(TimeGenerated, 1h)
| render timechart