Ax SQL queries summary analyze

Ax 2009, can be used in Ax2012

Tool 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:
ADPSQLAnalyze.png

Last edited Sep 30, 2015 at 8:07 PM by MarisOrbidans, version 4