Configuring Dashboards

• The Charts created in the monitoring can be pinned to Dashboard.
• This dashboard can be shared
  
  

Kusto Query Language (KQL)

• KQL is a powerful tool to explore your data and discover patterns, identify anamolies and outliers, Create statistical modeling and mored.
• Kusto Query: This is a read only request to process data and return results.
• To use KQL We can use Logs section and Query
  
• Other way is to install Azure Data Studio Refer Here
• The Quick Reference Refer Here
• SQL to KQL Cheatsheet Refer Here
• Refer Here for log queries
• Lets start by writing simple Conditions

VMProcess | where ExecutableName == "WaAppAgent" 

* Now lets try to understand a complex query

// Loading Data 
// Monitor data loading in the last hour. 
AzureMetrics
| where ResourceProvider == "MICROSOFT.SQL"
| where TimeGenerated >= ago(60min)
| where MetricName in ('log_write_percent')
| parse _ResourceId with * "/microsoft.sql/servers/" Resource// subtract Resource name for _ResourceId
| summarize Log_Maximum_last60mins = max(Maximum), Log_Minimum_last60mins = min(Minimum), Log_Average_last60mins = avg(Average) by Resource, MetricName

• We can also render charts.