Trace Parser – Ax2012

If you find any performance issues in the code or if Ax moves to not- responding mode in mid of executing a process, developer can take the help of readily available tool in Ax – Trace Parser.
User can analyse the events which causes performance bottlenecks (X++ code taking longer time to execute, indefinite while loops etc) .
I am not explaining the steps in trace parser installation in this post. Our focus will be on its usage and how it helps developer when there is a performance hit.
How to reach this tool in Ax?
1
By default, the parameters , “Xpp” and “BindingParameters” are disabled. You need to enable it.
2
Click “Start Trace” and specify a file name. . Execute the scenario which gives performance issue . Once done, “Stop Trace” and this will create a trace file .
Now click “Open Trace” button. In case you get any error in opening the file,
4
go to start and type Trace parser
5
You can import the trace file . Attach your session to investigate the scenario.
6
Call Tree tab shows the hierarchy of events happened.  Long duration tasks are highlighted in red which helps the developer to analyse the code.
12
X++/RPC tab – You can sort it by exclusive and inclusive and find the calls taking most of the time.  There is a call stack tab which shows the trace of the methods called.
 14
SQL tab : It shows the db calls and it helps the developer to check the DB statements which consumes more time . It can give us the clue if any index is missing or an insert during the index causes the problem.
With this, we get basic idea on using Trace parser. I am briefing you about another tool from SQL side which is called “Activity monitor”.
This tool ,when used with Trace parser helps to fix the performance issue in the application. You should have administrator permission to trigger this tool.
Option 1
8
Option 2 : Shortcut icon
9

The column “Head Blocker” specifies if there is any process blocked during execution .We will also get to know the dependant process is affected by this block.

10
In order to kill the blocking process, right click and select the option “Kill”.
To dig more the details, click “Details” tab which gives a hint on the statements that are causing the block.

11

So  Activity monitor and Trace parser go hand in hand to pull out the performance issue without investing more time in probing the issue.
Advertisements

About AnithaEswaran

Hello all, Thanks for visiting my blog. I started this blog to share my learning with Ax members . Since I am from technical background, most of my posts would be from X++. Thanks to my mentor and my colleague Romain who guided and helped me in learning many new concepts in Ax. This instilled confidence in me to handle and troubleshoot complex issues. Feedback wrt to my blog entries are most welcome …
This entry was posted in Ax 2012, Performance, Tracing and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s