Forum Discussion

Copper Contributor

Jun 29, 2018

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-...

Azure Log Analytics

azure monitor

Noa Kuperberg

Microsoft

Jul 09, 2018

Hi 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

Copper Contributor

Jul 11, 2018

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 Lambert

Copper Contributor

Jul 11, 2018

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