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.
Get Microsoft Dynamics AX 2012 Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
