(MOC 80428) SQL Optimization for AX 2012 provides individuals with the knowledge and skills to configure and maintain the performance of Microsoft Dynamics AX 2012.

Prerequisites

Before reviewing this training, individuals must have attended the following training courses:

• Development IV in Microsoft Dynamics AX 2012.
• Installation and Configuration for Microsoft Dynamics AX 2012.

Audience

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

At Training Material Completion

After completing this training, individuals 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 to 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.