Query Details
Use Case: Analyze and identify processes by their average, maximum, and minimum memory usage in order to pinpoint memory-intensive applications for optimization or troubleshooting purposes. Query: Process | summarize AvgMemoryUsageBytes=avg(WorkingSetSizeBytes), MaxMemoryUsageBytes=max(WorkingSetSizeBytes), MinMemoryUsageBytes=min(WorkingSetSizeBytes) by ProcessName | order by AvgMemoryUsageBytes desc | project ProcessName, AvgMemoryUsageBytes, MaxMemoryUsageBytes, MinMemoryUsageBytes
The query analyzes processes and calculates their average, maximum, and minimum memory usage. It groups the results by process name and orders them based on the average memory usage in descending order. The final output includes the process name, average memory usage, maximum memory usage, and minimum memory usage. This information can be used to identify memory-intensive applications for optimization or troubleshooting purposes.

Ugur Koc
Released: February 4, 2024
Tables
Keywords
Operators