SQL Optimization for Microsoft Dynamics AX 2012 training course
Course 80428
|
|
Course Overview
This two-day instructor-led course provides students with the knowledge and skills to configure and maintain the performance of Microsoft Dynamics AX 2012.
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
Course 80428: SQL Optimization for Microsoft Dynamics AX 2012 is designed for experienced Dynamics AX programmers that have a minimum of 2 years development experience.
Course 80428: SQL Optimization for Microsoft Dynamics AX 2012 is designed for experienced Dynamics AX programmers that have a minimum of 2 years development experience.
Course Outline
Module 1: Infrastructure and Capacity Planning for Microsoft Dynamics AX 2012 This module provides the high level information that is required for an administrator to perform sizing for an instance of Microsoft Dynamics AX 2012. To perform this sizing, an administrator must combine his or her understanding of the Microsoft Dynamics AX 2012 architecture, and the performance characteristics with relevant information on how Microsoft Dynamics AX 2012 will be used. In this module, you learn the fundamentals of the Microsoft Dynamics AX 2012 system architecture. Sizing guidelines and benchmarks are included to use as references. Additionally, the guidelines and benchmarks are provided with a sample set of questions to ask a company that relate to performance. Lessons
Module 2: Configuration Best Practices This module discusses many of the settings that affect the performance of Microsoft SQL Server 2012, the Microsoft Dynamics AX 2012 client, and the Microsoft Dynamics AX 2012 Application Object Server (AOS). This module also describes how to create maintenance plans so that the database continues to run more efficiently. Lessons
Module 3: Database Design Considerations This module describes design techniques that can improve database performance in Microsoft Dynamics AX 2012. Lessons
After completing this module, students will be able to:
Module 4: X++ SQL Code Best Practices This module discusses the two primary ways to make a single query run faster—index tuning and query tuning. Index tuning improves a query’s performance by adding indexes, and query tuning improves a query’s performance by rewriting the query. Lessons
Lab : Query Tuning After completing this module, students will be able to:
Module 5: Microsoft Dynamics AX 2012 X++ Coding for Performance Best Practices In this module, you will learn the common performance design patterns and the correct code placement when you develop customizations for Microsoft Dynamics AX 2012. You will learn how to develop batch jobs and consider tasks with parallelism, and you will also explore the techniques to use to limit client-side running code on forms. Lessons
Module 6: Post-Implementation: Monitoring and Performance This module describes how to monitor and tune the performance of Microsoft Dynamics AX 2012. Lessons
After completing this module, students will be able to:
|
Have a Microsoft Voucher? |
Alexandria | Atlanta | Austin | Baltimore | Birmingham | Boise | Boston | Boulder | Buffalo | Charleston | Charlotte | Chicago | Cincinnati | Cleveland | Columbus | Dallas | Denver | Des Moines | Detroit | Hartford | Houston | Indianapolis | Jacksonville | Kalamazoo | Las Vegas | Los Angeles | Melville | Nashville | New Orleans | New York | Orlando | Overland Park | Palm Beach Gardens | Philadelphia | Phoenix | Pittsburgh | Princeton | Providence | Raleigh | Reno | Salt Lake City | San Antonio | San Diego | San Francisco | Savannah | Scottsdale | Seattle | St. Louis | Tallahassee | Tampa | Toronto | Washington DC | Wichita