C# and AX Development: AX Database Performance

[Blog bot]

Источник: http://olondono.blogspot.com/2008/08...rformance.html
==============

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

http://blogs.msdn.com/axperf/archive...st-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 SET READ_COMMITTED_SNAPSHOT ON;
- Physical storage configuration (RAID, separate logs and data files, etc.)



Источник: http://olondono.blogspot.com/2008/08...rformance.html