323-WindowsService

Sample files shared at the architect day(s) 19th-20th of November

KQL

Here are some sample KQL queries used in demos.

Log Analytics queries

Note: Perf will be moved to InsightsMetrics soon.

Perf
| where ObjectName == "Process" and
        CounterName == "% Processor Time" and
        Computer == "vmname" and
        InstanceName == "CalcService"

Perf
| where TimeGenerated >= ago(3h) and
        ObjectName == "Process" and
        CounterName == "% Processor Time" and
        Computer == "vmname" and
        InstanceName == "CalcService"
| summarize max(CounterValue) by bin(TimeGenerated, 1m), Computer
| render barchart kind=unstacked

AzureMetrics 
| where ResourceGroup =~ "db-prod-rg" and
        Resource =~ "db" and 
        MetricName =~ "dtu_consumption_percent"

Application Insights queries

customEvents 
| where timestamp >= ago(30m) and
        appName =~ "CalcService" and
        name =~ "Calculation execution completed"
| extend Value = todouble(customMeasurements.Level) 
| project  timestamp, Value 
| summarize max(Value) by bin(timestamp, 1m)
| render timechart