1) Приводим SQL к требуемым параметрам
http://blogs.msdn.com/b/axinthefield/archive/2013/06/18/top-10-issues-discovered-from-premier-field-engineer-dynamics-ax-health-check.aspx
2) Анализируем индексы
http://dynamicsperf.codeplex.com/releases/view/122779
http://blogs.msdn.com/b/axinthefield/archive/2014/11/04/performance-analyzer-for-microsoft-dynamics-1-20-deployment-guide-dynamics-ax-installation.aspx
http://blogs.msdn.com/b/axinthefield/archive/2013/06/18/top-10-issues-discovered-from-premier-field-engineer-dynamics-ax-health-check.aspx
2) Анализируем индексы
http://dynamicsperf.codeplex.com/releases/view/122779
http://blogs.msdn.com/b/axinthefield/archive/2014/11/04/performance-analyzer-for-microsoft-dynamics-1-20-deployment-guide-dynamics-ax-installation.aspx