Query Details

Find Processes With High Memory Usage

Query

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

Explanation

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.

Details

Ugur Koc profile picture

Ugur Koc

Released: February 4, 2024

Tables

Process

Keywords

Process,AvgMemoryUsageBytes,MaxMemoryUsageBytes,MinMemoryUsageBytes,ProcessName

Operators

summarizeavgmaxminbyorder byproject

Actions