Unit testing query

(0) Share

Report

Posted on by Ganriver1

1,559

Hi Friends,

We have a report having performance issue, the query behind the report is likely the culprit.

Is there a good approach to test the query alone without running report? in other words, if we can dissect the query into sort of native sql statement to test, that would be ideal.

Many thanks,

River

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Martin Dráb 239,029 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Sure, you can either execute the AX query outside the report or take the actual T-SQL query sent to database and analyze it.

Was this reply helpful? Yes No
Ganriver1 1,559 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

How can I get the T-SQL query from query object in AOT?

Thanks,

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,029 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You can use Trace Parser or various options of SQL Server, such as Query Store, Extended Events or SQL profiler.

Was this reply helpful? Yes No
Ganriver1 1,559 on at

Like (0)

Report
Copy link

Link copied!

Thanks, Martin.

Was this reply helpful? Yes No