I have this simple query MyLog | summarize avg(executionTimeInMS_d) by bin(TimeGenerated, 5min) I'd like the summary to be in my local time zone, not UTC. This does not work : MyLog | summariz...

In Azure Monitor, there is a section called Insights that allows us to configure some kind of monitoring on a chosen set of resources like Applications, VMs, Storage Accounts, Containers etc. There...

I've used Prometheus to store performance metrics and query the results as percentiles (ex. 95th percentile response timing). I used prometheus-net to emit them. What is the equivalent in Azure Ap...

I have implemented an Azure alert that should fire when a Application Insights metric is greater than zero. The metric is the number of items in a Azure poison queue. The metric is calculated by a ...

I've added a chart using KQL and logs from Azure Log Analytics to a dashboard. I'm using make-series which works great but the catch is the following: The logs I'm getting might not extend to the w...

I find myself using the Kusto query language (KQL) via Azure Log Analytics, and I'm struggling to find a way to get any sort of detailed execution report or query plan. In PostgreSQL I'd use EXPLAI...

The following screenshot shows a day of SQL queries and the amount of resources they consume. As you can see, single queries, while there are many don't seem to consume much resources. The bar cha...

I've got an ASP .Net Core 3.0 Web API hosted on Azure App Service. I'm am trying to figure out why it's throwing a 500 Internal Server Error in one of the controller action methods. I've got Applic...

I have a kql-query which calculates number of uploaded BLOBS in Azure storage since last 24 hours. The query blow returns a number as expected when run in Azure log analytics. StorageBlobLogs | whe...

I'm using Azure Monitor/Log Analytics to trigger alerts successfully. I'm trying to get the alerts into a Microsoft Teams channel (as well as a slack channel for debugging) with no success. I've a...

I have created Azure Log Analytics (Monitor) Alert to monitor the Logic App Failures and I have done this using Azure portal. I would like to know how can we export the Alert created from Azure Por...

To create diagnostic settings on an Azure Firewall I want to pass in logs and metrics settings. I define these in 2 variables and then pass 'em into Azure CLI: $logsSetting = "[{'category': 'Azur...

With the new Azure SQL Database tier structure, it seems important to monitor your database "DTU" usage to know whether to upgrade or downgrade to another tier. When reading Azure SQL Database Ser...

We've recently started using Azure to host some virtual machines, but I've got problems getting the grips on the available resource monitoring metrics. When I go to the dashboard for the virtual m...