SQL Optimization for Microsoft Dynamics AX 2012 Course Number 80428

[Vadik]

This training provides individuals with the knowledge and skills to configure and maintain the performance of 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.

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

Customersource