Training course

SQL optimisation

Course code
80428A
Course duration
2 days
Course level
200
Dynamics version
Dynamics 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
Microsoft Certified Trainer

All our instructors are Microsoft certified and have a minimum of ten years’ training and real-world Dynamics experience. ANEGIS also provides professional technical equipment and fully equipped training rooms.

Book this course today