Azure monitoring

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!

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.

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 :)