Perfview in Dyn365FO. Part 5 - How to analyze X++ traces in perfview.
You can use PerfView for X++ traces analysis in troubleshooting scenarios.
See the First part for the introduction and a list of posts.
Dynamic 365 for Finance and Operations uses ETW technology for doing it’s own traces.
Compiler generates code that inserts an event before and after each method call. Also database engine reports all queries as ETW events.
Traces can be collected from UI or by using Trace Parser.
After that it can be opened in trace parser for analysis. Trace parser provides list of events, tree of calls and list of SQL queries.
That works good. But in some trouble shooting scenarios it can be usefule to search across events. In that case we can use Perfview.
How to use PerfView
We can open eny ETL in PerfView since it shares the same ETW technology with TraceParser.
Unfortunately, we cannot use stack viewer for X++ methods in this trace (you can use perfview to collect .NET trace ) though, but we can use this tool so see event sequence.
Do the following steps on a machine with Dyn365FO installed:
- Launch PerfView and navigate to a folder
- Double click “events”
- Select all event types at the left:
- Click on any event type
- Presss Ctrl+A
- Press F5 to refresh
- Setup columns to display:
FormattedMessage methodName sqlStatement *(where * means “all other columns” )
- Filter events by text. Unfortunately Perfview shows limited number of events (MaxRet input box). We can reduce number of viewed events by:
- excluding event types from the left pane
- filtering by text (Text Filter)
- limiting by time range (Start, End)
- After finding a time range where happens something that we are interested in, we can remove Text Filter and set Start and End instead.
- We can also use text filter to filter by activity id (since TraceParser catches all the session on the same AOS).