Course 80428A: SQL Optimization for Microsoft Dynamics AX 2012
- 1. Infrastructure and Capacity Planning for Microsoft Dynamics AX 2012
- 2. Configuration Best Practices
- 3. Database Design Considerations
- 4. X++ SQL Code Best Practices
- 5. Microsoft Dynamics AX 2012 X++ Coding for Performance Best Practices
- 6. Post-Implementation. Monitoring and Performance
1. 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
2. Configuration Best Practices
- SQL Server Configuration
- Microsoft Dynamics AX 2012 Settings
- Design Effective SQL Server Maintenance Plans
3. Database Design Considerations
- Create and Maintain Database Objects
- Data Types
- Table Caching
- Table Inheritance
- Temporary Tables
- Indexing
- Concurrency Control
- Data Compression
4. X++ SQL Code Best Practices
- Index Tuning
- Query Tuning
5. 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
6. 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