Query Details
Analyze Start Times And Run Durations Of Processes
Query
Use Case: Identifying and analyzing the processes within a system that have experienced the longest durations, helping prioritize optimization efforts. Query: Process | project ProcessName, StartDateTime, ElapsedTimeInMinutes = ElapsedTimeMilliseconds / 60000, ElapsedTimeMilliseconds | where ElapsedTimeMilliseconds > 0 // Ensures we focus on processes that have started and have a measurable duration | order by ElapsedTimeInMinutes desc // Orders the results to highlight processes with the longest durations first
Explanation
The query is used to identify and analyze the processes in a system that have taken the longest time to complete. It helps prioritize efforts to optimize these processes. The query selects the process name, start date and time, elapsed time in minutes, and elapsed time in milliseconds. It filters out processes with zero duration and orders the results in descending order of elapsed time in minutes to highlight the processes with the longest durations.
Details
Ugur Koc
Released: February 4, 2024
Tables
Process
Keywords
Process,StartDateTime,ElapsedTimeInMinutes,ElapsedTimeMilliseconds,where,orderby
Operators
projectwhereorder by