80696 - SQL Optimization for Microsoft Dynamics AX 2012 R3 CU8 (1 Day)
Description
This training provides the knowledge and skills to configure and maintain the performance of Microsoft Dynamics AX 2012 R3 CU8.
Module 1: Infrastructure and Capacity Planning.
Lesson 1: Microsoft Dynamics AX 2012 Architectural Review..
Lesson 2: Sizing Questions - Part I
Lesson 3: Sizing Questions - Part II
Lesson 3: Sizing Questions - Part III
Lesson 4: Hardware Sizing Resources.
Lesson 5: Database Sizing Guidelines.
Lesson 6: Application Object Server Sizing Guidelines.
Lesson 7: Enterprise Portal Server Sizing Guidelines.
Lesson 8: Integration Server Sizing Guidelines.
Lesson 9: Terminal Server Sizing Guidelines.
Lesson 10: Day in the Life Benchmark.
Lesson 11: Enterprise Portal Benchmark.
Lesson 12: Hyper V Benchmark.
Lesson 13: High Volume Inventory Benchmark.
Lesson 14: Moving from Theory to Practice: Create a Network Plan..
Lesson 15: Moving from Theory to Practice: Considerations.
Lesson 16: Module Review..
Module 1 Key Take Away.
Test Your Knowledge Module 1.
Test Your Knowledge Ans
Module 1.
Module 2: Configuration Best Practices.
Lesson 1: SQL Configuration: Overview..
Lesson 2: SQL Configuration: Operating System Settings.
Lesson 3: SQL Configuration: SQL Server Service Account.
Lesson 3: SQL Configuration: Configuring SQL Server.
Lesson 4: SQL Configuration: Trace Flags.
Lesson 5: SQL Configuration: Temp Database.
Lesson 6: SQL Configuration: Configure the AX Database.
Lesson 7: Server Configuration..
Lesson 8: AX Settings.
Lesson 9: Batch Configuration.
Lesson 10: Design Effective SQL Server Maintenance Plans.
Lesson 11: Module Review..
Module 2 Key Take Away.
Module Practice.
Practice Module 2 Scenario 1: Verify Settings.
Practice Module 2 Scenario 2: Database Maintenance.
Test Your Knowledge Module 2.
Test Your Knowledge Answers.
Module 2.
Answer justification..
Module 3: Database Design Considerations.
Lesson 1: Create and Maintain Database Objects.
Lesson 2: Data Types.
Lesson 3: Table Caching.
Lesson 3: Table Caching Guidelines.
Lesson 4: Table Inheritance.
Lesson 5: Temporary Tables.
Lesson 6: Indexing..
Lesson 7: Clustered Index Usage.
Lesson 8: Non-Clustered Index Usage.
Lesson 9: Column Order.
Lesson 10: Included Columns.
Lesson 11: Concurrency Control.
Lesson 12: Data Compression..
Lesson 13: Module Review..
Module 3 Key Take Away.
Module Practice.
Practice Module 3 Scenario 1: Table Caching.
Test Your Knowledge Module 3.
Test Your Knowledge Answers.
Module 3.
Answer justification..
Module 4: X++ SQL Code Best Practices.
Lesson 1: Index Tuning Process: Overview..
Lesson 2: Index Tuning Process: Identify Query in SQL Server Management Studio..
Lesson 3: Index Tuning Process: Create and Analyze an Execution Plan..
Lesson 3: Index Tuning Process: Parameter Sniffing..
Lesson 4: Index Tuning Process: Add and Test Index Changes.
Lesson 5: Demonstration: Index Tuning
Lesson 6: Query Tuning: Overview..
Lesson 7: Query Tuning: Database Bulk Updates.
Lesson 8: Query Tuning: Loops and Where Clause.
Lesson 9: Query Tuning: Aggregates, Minimize Data Returned and Index Hints.
Lesson 10: Demonstration: Query Tuning..
Lesson 11: Module Review..
Module 4 Key Take Away.
Module Practice.
Practice Module 4 Scenario 1: Index Tuning.
Practice Module 4 Scenario 2: Query Tuning.
Test Your Knowledge Module 4.
Test Your Knowledge Answers.
Module 4.
Answer justification..
Module 5: X++ Coding for Performance Best Practices.
Lesson 1: Development Practices to Do and Not Do: Loops, Conditionals and Fieldlists.
Lesson 2: Development Practices to Do and Not Do: Aggregations and Transaction Scoping.
Lesson 3: Development Practices to Do and Not Do : UI Interaction..
Lesson 3: Development Best Practices.
Lesson 4: Code Placement.
Lesson 5: Batching and Batch Strategies: SysOperationFramework.
Lesson 6: Batching and Batch Strategies: Batch Bundling.
Lesson 7: Batching and Batch Strategies: Individual Task Model
Lesson 8: Batching and Batch Strategies: Top Picking..
Lesson 9: Form Considerations.
Lesson 10: Response Time Expectations.
Lesson 11: Module Review..
Module 5 Key Take Away.
Test Your Knowledge Module 5.
Test Your Knowledge Answers.
Module 5.
Answer justification..
Module 6: Post-implementation: Monitoring and Performance.
Lesson 1: Performance Tuning Approach.
Lesson 2: Locking, Blocking, and Deadlocks. 81
Lesson 3: SQL Server Reporting Services (SSRS) Tuning.
Lesson 3: Enterprise Portal Performance Tuning..
Lesson 4: Performance Analyzer (DynamicsPerf)
Lesson 5: AX Trace Parser.
Lesson 6: System Diagnostics on Lifecycle Services.
Lesson 7: Windows Performance Monitor (PerfMon)
Lesson 8: Other Tools.
Lesson 9: Tools to be Cautious About.
Lesson 10: Common Intermediate Language (CIL).
Lesson 11: Module Review..
Module 6 Key Take Away.
Module Practice.
Practice Module 6 Scenario 1: Trade Parser.
Test Your Knowledge Module 6.
Test Your Knowledge Answers.
Module 6.
Answer justification
Prerequisites:
Before viewing this training, individuals must have viewed:
- 80313: Development IV in Microsoft Dynamics AX 2012
- 80672: Installation and Configuration for Microsoft Dynamics AX 2012 R3 CU8