Nov 14 2018
01:09 AM
- last edited on
Apr 07 2022
05:32 PM
by
TechCommunityAP
Nov 14 2018
01:09 AM
- last edited on
Apr 07 2022
05:32 PM
by
TechCommunityAP
Hello!
First and foremost, I'm new to Azure and Azure monitoring. That's why I'm starting this conversation.
I'm currently trying to migrate our SolarWinds monitor into the Azure monitoring portal, but I'm unable to carry on because my knowledge about queries is absolutely minimum.
I would like some assistance when it comes to queries, does anybody for instance know a query to monitor the CPU load on different computers and/or servers? And which tile in the designer should I use for this query?
I hope some of you can help me out :)
Kind regards,
Rik
Nov 14 2018 02:49 AM
Getting this information is quite easy when using the Metrics in Azure Monitor:
If you want to use log analytics, you could try something like this:
Another way of visualizing can be done using VM Insights from the VM Blade of from Azure Monitor:
Some good starting points:
https://docs.microsoft.com/en-us/azure/azure-monitor/overview
https://docs.microsoft.com/en-us/azure/log-analytics/log-analytics-queries
https://azure.microsoft.com/nl-nl/blog/rich-insights-for-virtual-machines-from-azure-monitor/
Have fun with this amazing set of tools :)
Nov 14 2018 03:47 AM
Nov 14 2018 04:17 AM
I think you can make a quickstart by implementing the following solution, this will give you a lot of tiles out of the box:
http://blogs.catapultsystems.com/cfuller/archive/2017/11/28/updating-the-server-and-client-performan...
Download the solution here: https://gallery.technet.microsoft.com/scriptcenter/Server-Performance-3d767ab1
Nov 14 2018 04:28 AM
Here is a query you can use to view CPU for computers reporting into Log Analytics.
//CPU Time
Perf
| where CounterName == "% Processor Time"
| summarize CUPTime=avg(CounterValue) by bin(TimeGenerated, 5m), Computer
| render timechart
Run this from the Logs or Logs(Classic) blade to see the results. The ComputerName value "% Processor Time" can be replaced by any other value if you want to chart something else. Be sure these values are added for collection from the Advanced Settings > Data blade in the workspace.
Tiles are used for pre-created views and queries, not for running queries. Tiles can be added manually or with solutions. The Security and Compliance solution gives a lot of useful information, it also will enable security log collection.
If you are looking for more on writing queries, take a look at the Pluralsight Kusto Query Language from Scratch course. Microsoft's documentation has also improved quite a bit.
Nov 14 2018 05:18 AM
Best place to learn the query language (I send everyone I talk to about Log Analytics here):
https://app.pluralsight.com/library/courses/kusto-query-language-kql-from-scratch/table-of-contents
Enjoy!