Ax Trace Parser Doesnt Show SQL Queries

Question

Configuring the tracing cockpit to show sql events, traceparser doesn't show the sql tab, how can I get the sql queries from trace parser?

And one second question, It also shows only my queries,is there a way to make it show all queries running in ax?

Jan B. Kjeldsen · Answer 1 · 2014-11-12T12:58:56.337

0

See how to Install the Trace Parser. Also ensure you run it from the AOS server and that the correct event selection is provided.

Also start AX with escalated privileges (Run as administrator).

edited Nov 12 '14 at 12:58

answered Nov 12 '14 at 12:09

Jan B. Kjeldsen

From the look of it,everything looks the way things should be,Trace Parser is installed properly with proper connection to AOS server,and event selection looks normal as well :( – Sin5k4 Nov 12 '14 at 12:38
Did you install TP on the SQL Server? Not sure, but I remember I had to install on SQL, AOS and client ... – Jan B. Kjeldsen Nov 12 '14 at 12:51
Also your problem may be permission related, check logs. – Jan B. Kjeldsen Nov 12 '14 at 15:34
Looks like I needed a server session to see the trace logs. – Sin5k4 Nov 13 '14 at 08:07

1 Answers1