SQL Optimisation for Microsoft Dynamics® AX 2012

At Course Completion

• 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.

Course Requirements:

Students looking to take this course (80428) must already have the following technical knowledge:

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