Offset Column Ask

Question

Can we add an offset column to the "Available Columns" in the CPU Usage (Sampled) View Editor? When we capture XPerf traces from live SQL instances using the Address column helps us pinpoint the right instruction, however these are virtual addresses from the process space, and offline analysis doesn't work here. We can use the offset column to find the same address when we open the binary with windbg, so we can do further analysis on hot functions without having to have the process running.

Answer 1

Hello Devin,

The view editor for "CPU Usage (Sampled)" can be used to add a column named "Image RVA"; "Image RVA" is what you probably mean by "offset" (RVA = Relative Virtual Address).

The .etl file needs to include Image Load/Unload/Rundown events in order to calculate the "Image RVA" value.

Assuming that the .etl file contains Image Load/Unload/Rundown events, Process Create/Terminate/Rundown events and Sampled Profile events then there is no need that the "process of interest" should still be running; indeed, the trace could be analysed on another system and the RVA information would still be calculable. Including ImageId events in the trace would make converting "Image RVA" values into function (symbol) names plus offsets straightforward.

Gary