Forum Discussion
Devin Lambert
Jun 29, 2018Copper Contributor
Multidimension timechart
Hello, So first off, i've already reviewed this answer, and it seems hacky. https://techcommunity.microsoft.com/t5/Azure-Log-Analytics/Azure-log-analytics-timechart-with-multiple-dimensions/td-...
Noa Kuperberg
Microsoft
Jul 09, 2018Hi Devin,
I'm not sure what you get vs. what you want to get - can you add a picture?
I've created a similar query on our demo data:
(Perf | where ObjectName == "Processor" and CounterName == "% Processor Time" and InstanceName == "_Total" and Computer contains "Contoso" and TimeGenerated > ago(1h) ) | union (AzureDiagnostics | where Category=="ApplicationGatewayPerformanceLog" and Resource contains "Contoso" and TimeGenerated > ago(1h) | project TimeGenerated, latency_d ) | summarize avg(latency_d), avg(CounterValue) by bin(TimeGenerated, 5m) | render timechart
and it produces this output:
Were you aiming for something very different?
Devin Lambert
Jul 11, 2018Copper Contributor
Sorry, I never got notified on your reply. I realized the fundamental issue with my problem. I didn't have a common Y Axis.
Here is a new query.
(
Perf
| where
ObjectName == "Processor"
and CounterName == "% Processor Time"
and InstanceName == "_Total"
and Computer contains "CD"
and TimeGenerated > ago(7d)
| project CPU_Utilization=CounterValue, TimeGenerated
)
| union
(
AzureDiagnostics
| where
Category == "LoadBalancerProbeHealthStatus"
and Resource == "SITECORE-PROD-CD-EXTERNAL-LB"
and TimeGenerated > ago(7d)
| project TimeGenerated, dipCount=totalDipCount_d
)
| summarize dipCount=max(dipCount)*10, avg(CPU_Utilization) by bin(TimeGenerated, 1h)
//, Computer=extract(@"([^\.]*)", 1, Computer )
| render timechart
- Devin LambertJul 11, 2018Copper Contributor
Here is another query that further exemplifies the concept.
(
Perf
| where
ObjectName == "Processor"
and CounterName == "% Processor Time"
and InstanceName == "_Total"
and Computer contains "CD"
and Computer !contains "azecdag01"
and Computer !contains "azescdb03"
and Computer !contains "azescdb00"
and TimeGenerated > ago(7d)
| project CPU_Utilization=CounterValue, TimeGenerated
)
| union
(
Perf
| where
ObjectName == "Memory"
and CounterName == "% Committed Bytes In Use"
and TimeGenerated > ago(7d)
| project Mem_Utilization=CounterValue, TimeGenerated
)
| union
(
app("Sitecore Production").pageViews
| where timestamp > ago(7d)
| summarize count() by bin(timestamp,1h)
| project TimeGenerated=timestamp, pageViews=count_
)
| union
(
app("Sitecore Production").pageViews
| where timestamp > ago(7d)
| summarize count() by session_Id, bin(timestamp,1h)
| summarize count() by bin(timestamp, 1h)
| project TimeGenerated=timestamp, sessions=count_
)
| summarize avg_pageviewsx100=avg(pageViews)/100, avg_sessionsx100=avg(sessions)/100, avg(CPU_Utilization), avg(Mem_Utilization) by bin(TimeGenerated, 1h)
| render timechart