Jul 30 2019
04:40 AM
- last edited on
Apr 07 2022
06:01 PM
by
TechCommunityAP
Jul 30 2019
04:40 AM
- last edited on
Apr 07 2022
06:01 PM
by
TechCommunityAP
Jul 31 2019 07:32 AM
May we be we can create a temp table and join the two data sets to have perf counter values in columns instead of row. If someone could help give an example of that may also help
Aug 05 2019 01:50 AM
You can store the results using the Let statement - note, all three lets must return data for this to work - thats why I have commented out two lines as I don't have "% used memory" data in the workspace
Go to Log Analytics and Run Query
let commitedBytes = (Perf
| where ObjectName =="Memory" and CounterName=="% Committed Bytes In Use"
| summarize AvgCommitedBytes=avg(CounterValue) by Computer);
let usedMemory = (Perf
| where ObjectName =="Memory" and CounterName=="% used memory"
| summarize AvgUsedMemory=avg(CounterValue) by Computer);
let availableBytes = (Perf
| where ObjectName =="Memory" and CounterName=="Available MBytes"
| summarize AvgAvailBytes=avg(CounterValue) by Computer);
commitedBytes
//| join kind=inner (usedMemory) on Computer
| join kind=inner (availableBytes) on Computer
| project Computer,
AvgCommitedBytes,
// AvgUsedMemory,
AvgAvailBytes