Shulou(Shulou.com)06/03 Report--

Query the collected data

We can use the following query statement to query servers with memory less than 1024MB:

Let setMBValue = 1024 Available MBytes Memory startDate = ago (12h); / / enter how many days/hours to look back onPerf | where TimeGenerated > startDate | where ObjectName = = "Memory" and CounterName = = "Available MBytes Memory" and Computer in ((Heartbeat | distinct Computer)) | extend FreeMemory = CounterValue | summarize FreeMemoryMB = min (FreeMemory) by Computer | where FreeMemoryMB

StartDate | where ObjectName = "Memory" and CounterName = = "Available MBytes Memory" and Computer in ((Heartbeat | distinct Computer)) | extend FreeMemory = CounterValue) on Computer | make-series Free_Memory_MB = min (FreeMemory) on TimeGenerated from ago (8h) to now () step 2h by Computer | render timechart

Create Alert

If we want to set email, SMS and other alarm rules, we can create them by "+ New alert rule":

After the Alert is created, we will receive an alert when the system's available memory is lower than the 1024MB:

Fix the performance chart to the dashboard

We can also display the query results to Azure Dashboard by clicking the "fixed" button at the top right of the query window, and then selecting the Dashboard in which we want to display the icon:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.