SQL optimisation

Learn SQL optimisation knowledge and skills to configure and maintain your SQL Server instance to increase AX performance.

About

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

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
🡱