Источник:
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