Chapter 9. Improving Dynamics AX Performance

In this chapter, we will cover the following recipes:

• Calculating code execution time

• Writing efficient SQL statements

• Caching a display method

• Using Dynamics AX Trace Parser

• Using SQL Server Database Engine Tuning Advisor

Introduction

It is quite common for many larger Dynamics AX installations to suffer from performance issues. This could be caused by insufficient hardware, incorrect configuration, ineffective code, lack of user training, and many other reasons.

This chapter discusses how the system's performance could be improved by following several simple rules. This is not a complete guide for troubleshooting Dynamics AX performance issues, but a compilation of must-know information for developers.