January 15th, 2021

Windows Performance Analyzer – Table & Graph Configurations (Part 1)

Tristan Gibeau
Software Engineer Lead

In the previous post, we discussed a brief intro into Windows Performance Analyzer (WPA) and its feature set.  WPA can display trace data in a wide array of formats, most of which are pre-configured as presets designed for drilling into specific data points.

Here is one for example: WPA’s CPU Usage (Sampled) table has a few different presets, each reconfigures the view of both table and graph data.

Image CPU Usage Sampled Presets

This blog post is the first of a multi-part series that goes into detail on how to configure the table and graph views to create your own presets:

  • Configuring column options for tables (Aggregation/Format/Sort/Text Alignment) – Part 1
  • Configuring columns for graphing (Line/Bar/Gantt) – Part 2
  • Quick saving presets and profiles – Part 3

Column Options

Depending on the column’s data type, WPA can configure each column with one or more of the following options:

  • Aggregation
  • Sort
  • Format

Each set of options can be configured by either right clicking on the column header, or visiting the View Editor. Let’s dig into what each one of these options mean and the different ways to configure them.

Aggregation

When combined with the Pivot (Gold) Bar, can be powerful tool in understanding large data sets at a glance.  WPA will calculate the selected aggregation of all individual rows inside the pivot group on the fly as you expand/collapse, filter row data, and adjust the timeline zoom.

  • Average (Avg)
  • Count
  • Max
  • Min
  • Sum
  • Unique Count
  • Weighted Average (Weighted Avg)

As an example: open a trace captured with WPR’s General Profile and expand ‘System Activity’ and “double click” the Process Table in the ‘Graph Explorer‘. In the below table screenshot has aggregations applied to three different columns: Duration [Sum], Start Time [Min], and End Time [Max].  For each pivot/group to the left of the gold bar, the rows are calculated based on the aggregation selected. In the below table screenshot, ‘Transient’ is expanded to show the aggregated values for each sub group.

Image Table Aggregations

Each column can be configured with a different aggregation, which is especially useful for views that incorporate CPU, Memory, and Disk usage. The best way to get a feel for the power of aggregations is to open a table and play around with changing column aggregation modes and expanding/collapsing pivot groups.  So before continuing, I encourage you to jump in and try things out!

Sort

Columns in tables can be quickly sorted by clicking the column header. If you would like to sort the data based on it’s absolute value, simply hold CTRL key while clicking while clicking the column header to toggle.

Ascending Descending Ascending (Absolute) Descending (Absolute)
Image WPA Weight Ascending Image WPA Weight Descending Image WPA Weight Ascending Abs Image WPA Weight Descending Abs

Format

Column formats can hep present data in easier-to-read ways by doing things like changing the number of decimals in a floating point number, the time unites of time-based data, and the base (hex? decimal? go crazy) of a integer data point.

Supported Formats:

Time Nanoseconds

Microseconds

Milliseconds

Seconds

Numeric Decimal

Hexadecimal

Floating Point (%) Decimal Places (group/non group)
Size (Bytes) Bytes

Kilobytes

Megabytes

Gigabytes

 

As an example, open a trace captured with WPR’s General Profile and expand ‘Storage’ and “double click” Disk Usage in the ‘Graph Explorer‘. Switch to the ‘Size by Process, Path Name, Stack’ preset by clicking the drop down in the table’s title bar:

Image disk usage preset drop down

The Size column is displayed as Bytes by default. By right clicking on the column header, the format can be configured:

Image WPA Bytes Size Format Config

 

Conclusion

I hope this post give quick overview on how to configure columns to ease analysis in WPA. If you want to learn more, there are many more scenarios we did not cover that can be found at Microsoft Docs.

Keep a look out for Part 2 of this series where we dig into configuring the table columns for different graphing techniques!

Author

Tristan Gibeau
Software Engineer Lead

I work in the performance space at Microsoft. I have the privilege to work on great tooling such as Windows Performance Recorder, XPerf, ETW, and Windows Performance Analyzer, dedicated to improving reliability and performance across Windows & Microsoft’s platforms.

1 comment

Discussion is closed. Login to edit/delete existing comments.

  • AndrĂ© Rauh

    How can I graph my own Start/Stop events (which, for instance, give me DURATION_MSEC in PerfView) in a time line graph? Is that possible?