AX Database Performance

Here is an excellent post about AX database performance applying a checking list:

http://blogs.msdn.com/axperf/archive/2008/03/10/welcome-database-configuration-checklist-part-1.aspx

Some tips:

- Max Degree of Parallelism (MAXDOP instance-wide)
  - OLTP (normal operations0: Set Max Degree of Parallelism to 1)
  - Upgrade: set to # of physical processor cores, ...
- Activate AWE only for 32-bits systems
- Separate log and data files
- Configure several temp DBs
- Set Read-Committed Snapshot Isolation = true

ALTER DATABASE <ax database name>

    SET READ_COMMITTED_SNAPSHOT ON;

- Physical storage configuration (RAID, separate logs and data files, etc.)