Rod Willumsen has written a very fine book, Advanced X++/SQL Tuning Techniques, covering a lot of ground around performance work with Dynamics AX 2012 and Dynamics 365 FO.


The book starts out with a few chapters about various SQL subjects seen from AX/365 FO point of view.

Secondly it walks you through installation of the Performance Analyzer and of how to analyze the results collected by the analyzer.

Collecting traces and analyzing them with the trace parser, both for AX 2012 and D365, is covered in depth too.

You'll also find information about data archiving and data clean up techniques, as well as information about how to deal with very specific issues, like InventDim and InventSum tables, and master planning.

These are the chapters of the book:

  • X++ and SQL
  • Performance killers
  • Improving poor X++ query performance
  • Further query improvements
  • Performance analyzer for Dynamics
  • Microsoft Dynamics AX 2012 Trace Parser
  • D365FO Application Trace Parser
  • Top D365FO performance issues and solutions

DBAs, system administrators and developers as well should be able to pick up useful information and tools from this book.