SQL optimisation

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

Book now
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

What can we do for you?

We'd love to hear about your project. Our team will get back to you within two working days.

Thank you for inquiry, we’ve passed it to our sales department, our representative will reach you back in his earliest convenience.
Oops! Something went wrong while submitting the form.