80696 - SQL Optimization for Microsoft Dynamics AX 2012 R3 CU8

Code: 80696
Course duration: 1 days
Location Period
Northern New Jersey (Virtual Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Palm Beach County Florida (Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Greenwich, Connecticut (Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Attend Online 12-15
09:00AM to 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Palm Beach County Florida (Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Fort Lauderdale, Florida (Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Attend Online 01-12
09:00AM to 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Palm Beach County Florida (Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Mid-Town New York City (Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Attend Online 02-16
09:00AM to 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led) 03-16
09:00AM to 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led) 03-16
09:00AM to 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led) 03-16
09:00AM to 05:00PM
enroll
Palm Beach County Florida (Instructor-Led) 03-16
09:00AM to 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led) 03-16
09:00AM to 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led) 03-16
09:00AM to 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led) 03-16
09:00AM to 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led) 03-16
09:00AM to 05:00PM
enroll
Attend Online 03-16
09:00AM to 05:00PM
enroll
NYC-23rd Street (Instructor-Led) 03-16
09:00AM to 05:00PM
enroll

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

Guaranteed to Run

2018-03-07 09:00 to 2018-03-09 17:00
Fort Lauderdale, Florida (Virtual Instructor-Led)
2017-12-11 09:00 to 2017-12-15 17:00
Attend Online
2017-12-04 09:00 to 2017-12-08 17:00
Attend Online
2017-12-04 09:00 to 2017-12-08 17:00
Attend Online
2017-11-27 09:00 to 2017-12-01 17:00
Attend Online

Course Reviews

No reviews found for this course.

Be the first to write a review