Add custom performance counter in Azure Log Analytics workbook

By default, you have only limited number of performance counters only are available in Azure Log Analytics workbook. However, you may add custom performance counters as explained in my blog post here:
In this blog I have constructed a custom performance counter for 
Memory Pages/sec for virtual machines

Here are the steps you may need to follow:

Create New Workbook and add custom cmdlets
Go to Monitor ->Virtual Machines (Preview) page and open ‘View Work Books’

Go to Monitor ->Virtual Machines (Preview) page and open ‘View Work Books’

Add New Work Book, by clicking ‘+ New’ button there.
Paste the following sample Log Analytics Qury and try a ‘Run Query’ there


Perf | where CounterName == “Pages/sec” and ObjectName == “Memory” | summarize AggregatedValue = avg(CounterValue) by bin(TimeGenerated, 1m), Computer | render timechart

Save the Workbook with the desired name.
Now the workbook will appear in your workbook collection page as below:

Open the new workbook created to see the custom counter created by these steps. You may pin this workbook to dashboard for easy access and usage

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count:

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!

Leave a Reply

Your email address will not be published. Required fields are marked *

Bitnami