80428 SQL Optimization in Microsoft Dynamics AX 2012

Overview

Students will gain the knowledge and skills to configure and maintain the performance of Microsoft Dynamics AX 2012.

Objectives

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

Audience

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

Syllabus

Infrastructure and Capacity Planning for Microsoft Dynamics AX 2012

  • Microsoft Dynamics AX 2012 Architecture Review
  • Sizing Questions
  • Hardware Sizing Resources
  • Moving from Theory to Practice

Configuration Best Practices

  • SQL Server Configuration
  • Microsoft Dynamics AX 2012 Settings
  • Design Effective SQL Server Maintenance Plans
  • Lab : Verify Settings
  • Lab : Database Maintenance

Database Design Considerations

  • Create and Maintain Database Objects
  • Data Types
  • Table Caching
  • Table Inheritance
  • Temporary Tables
  • Indexing
  • Concurrency Control
  • Data Compression
  • Lab : Table Caching

X++ SQL Code Best Practices

  • Index Tuning
  • Query Tuning
  • Lab : Index Tuning
  • Lab : Query Tuning

Microsoft Dynamics AX 2012 X++ Coding for Performance Best Practices

  • Development Practices to Do and Not Do
  • Code Placement
  • Batching and Batch Strategies
  • Form Considerations
  • Response Time Expectations

Post-Implementation: Monitoring and Performance

  • Performance Tuning Approach
  • Locking, Blocking, and Deadlocks
  • SQL Server Reporting Services and Enterprise Portal Performance Tuning
  • Performance Analyzer for Microsoft Dynamics AX (DynamicsPerf)
  • Microsoft Dynamics AX Trace Parser
  • Microsoft Dynamics AX Diagnostic Framework (Beta)
  • Windows Performance Monitor (PerfMon)
  • Other Tools
  • Tools to be Cautious About
  • CIL
  • Lab : Trace Parser

Training provider

Teaching mode:
Classroom - Instructor Led
Online - Instructor Led
Duration: 2 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Microsoft Dynamics AX
Worldwide
This skill has an average salary of
US$75,043
and is mentioned in
0.07%
of job ads.
Microsoft SQL Server
Worldwide
This skill has an average salary of
US$83,907
and is mentioned in
1.74%
of job ads.
Database
Worldwide
This skill has an average salary of
US$71,285
and is mentioned in
10.88%
of job ads.
Database design
Worldwide
This skill has an average salary of
US$90,917
and is mentioned in
0.40%
of job ads.