SQL optimisation
Learn SQL optimisation knowledge and skills to configure and maintain your SQL Server instance to increase AX performance.
Book nowAbout
This two-day instructor-led course provides students with the knowledge and skills to configure and maintain the performance of AX 2012.
Agenda
Module 1: Structure and capacity planning
Lessons
- Microsoft Dynamics AX 2012 architecture review
- Sizing questions
- Hardware sizing resources
- Moving from theory to practice
Module 2: Configuration best practices
Lessons
- SQL derver configuration
- Microsoft Dynamics AX 2012 settings
- Design effective SQL server maintenance plans
Lab
- Verify settings
- Database maintenance
Module 3: Database design considerations
Lessons
- Create and maintain database objects
- Data types
- Table caching
- Table inheritance
- Temporary tables
- Indexing
- Concurrency control
- Data compression
Lab
- Table caching
Module 4: X++ SQL code best practices
Lessons
- Index tuning
- Query tuning
Labs
- Index tuning
- Query tuning
Module 5: X++ coding for performance
Lessons
- Development practices to do and not do
- Code placement
- Batching and batch strategies
- Form considerations
- Response time expectations
Module 6: Post-implementaiton and performance
Lessons
- Performance tuning approach
- Locking, blocking, and deadlocks
- SQL server reporting services and Enterprise Portal performance tuning
- Performance analyser
- Trace parser
- Diagnostic framework (Beta)
- Windows performance monitor (PerfMon)
- Other tools
- Tools to be cautious About
- CIL
More courses