Ax SQL queries summary analyze
Ax 2009, can be used in Ax2012Tool takes standard Ax "Long running SQL" logs (in Ax database) and shows summary statistics to overcome "Scroll blindness":
- slightly "normalize" similar queries (Little simplifying in filed list and removing excess brackets)
- summarize "similar" queries
- for each summarized query keeps call stacks and timing statistics for each
In result it is very easy to get top queries by total time AND exact source code which creates them.
Sample results screen:
