Azure monitoring

Not applicable



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,



7 Replies

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:


Have fun with this amazing set of tools :)



Hi Mark,
Thanks for your fast reply! I have one last question though, can I use that query in the designer? If so, which tile should I use?

Thanks once again for helping me out!

I think you can make a quickstart by implementing the following solution, this will give you a lot of tiles out of the box:


Download the solution here:

Here is a query you can use to view CPU for computers reporting into Log Analytics.


//CPU Time
| 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.



This one was perfect! Thank you!

Best place to learn the query language (I send everyone I talk to about Log Analytics here):



That is an excellent training!