SQL Optimization for Microsoft Dynamics AX 2012

  • Overview
  • Course Content
  • Drop us a Query

This two-day instructor-led course provides students with the knowledge and skills to configure and maintain the performance of Microsoft Dynamics AX 2012.

Audience Profile

This course is intended for experienced Dynamics AX programmers with a minimum of 2 years development experience.

At Course Completion

After completing this course, students will be able to:

  • Create a plan for Microsoft Dynamics AX 2012 infrastructure.
  • Configure parameters to improve the performance of Microsoft Dynamics AX 2012.
  • Create Maintenance plans in SQL Server.
  • Maintain the performance of Microsoft Dynamics AX 2012.
  • Design data structures in Microsoft Dynamics AX 2012 to improve their performance.
  • Evaluate table design structure in Microsoft Dynamics AX 2012 to improve performance.
  • Tune indexes.
  • Tune queries.
  • Review X++ best practices that affect performance.
  • Define a performance tuning approach.
  • Understand the tools available to monitor and solve performance problems.

SQL Optimization for MD AX 2012 Course Outline

  • Module 1: Infrastructure and Capacity Planning for Microsoft Dynamics AX 2012
  • Module 2: Configuration Best Practices
  • Module 3: Database Design Considerations
  • Module 4: X++ SQL Code Best Practices
  • Module 5: Microsoft Dynamics AX 2012 X++ Coding for Performance Best Practices
  • Module 6: Post-Implementation: Monitoring and Performance
  • Project/Lab

A Few Things You'll Love!

Students Speak