Forum Discussion

Copper Contributor

May 08, 2019

CPU, Memory and Hard Drive Baseline Specs

Hi Everyone, Background: We have more than terabytes of data we've collected over the last week. We've stopped the collection this week. And we now have 30 days to either pull the data and put it...

azure monitor

Query Language

rockypabillore

Copper Contributor

May 09, 2019

CliveWatsonThanks for the suggestions! here's the list that I've been pulling:

When I run the Core Counts its giving me this:

Is that right?

I'm also getting no results for the hard drive space query:

CliveWatson

Former Employee

May 09, 2019

Hi rockypabillore

He is an updated cores query, that should work better?

// count cores on each computer, exclude _total with regex
Perf
| where CounterName == "% Processor Time"  and ObjectName == "Processor"
| where InstanceName matches regex '[0-9]'
| summarize Cores = dcount(InstanceName), CoreList = make_set(InstanceName) by  Computer

Perf
| where CounterName == "% Processor Time" and ObjectName == "Processor"
| where InstanceName matches regex @'[0-9]'
| summarize Cores = dcount(InstanceName) by  Computer
| sort by Cores desc 
| render barchart

It doesn't look like you have "free megabytes" counter, so the query just needs to be:

let myPCT = 100;
Perf
| where CounterName == "% Free Space"
| where TimeGenerated > startofday(ago(1d))
| where InstanceName has ":" and strlen(InstanceName) ==2
// only look at drive letters
| summarize PctFree=round(avg(CounterValue),2) by Computer,InstanceName
| where PctFree <= myPCT
| sort by PctFree  desc

Vinayaka2210

Copper Contributor

Jul 06, 2020

Hi CliveWatson

with the help of below query can I get the Cores Utilization.?

I was refering to the Article : https://docs.microsoft.com/en-us/azure/azure-monitor/platform/metrics-supported

But I couldn't make anything using Metric as well.

// count cores on each computer, exclude _total with regex
Perf
| where CounterName == "% Processor Time"  and ObjectName == "Processor"
| where InstanceName matches regex '[0-9]'
| summarize Cores = dcount(InstanceName), CoreList = make_set(InstanceName) by  Computer

Thanks,

Vinayaka

CliveWatson

Former Employee

Jul 07, 2020

Vinayaka2210

// count cores on each computer, exclude _total with regex
Perf
| where CounterName == "% Processor Time"  and ObjectName == "Processor"
| where InstanceName matches regex '[0-9]'
| summarize Cores = dcount(InstanceName), pctbyCore= sum(CounterValue) by  Computer, InstanceName


// count cores on each computer, exclude _total with regex, every 6 hrs 
Perf
| where CounterName == "% Processor Time"  and ObjectName == "Processor"
| where InstanceName matches regex '[0-9]'
| summarize Cores = dcount(InstanceName), pctbyCore= sum(CounterValue) by  Computer, InstanceName, bin(TimeGenerated,6h)

vinayaka51091
Copper Contributor
Mar 09, 2021
Hi CliveWatson,

from the above query how " Cores = dcount(InstanceName) " is considered with Instance Name.

I mean how cores is calculated with count of Instance Name.

Thanks,
Vinayaka