Microsoft Dynamics AX Database RAID Configuration Hints

When you set up the SQL Server database for Microsoft Dynamics AX 2012, follow these storage principals.

• Store Microsoft Dynamics AX 2012 Online Transactional Processing (OLTP) database data files and transaction log files on separate physical stores.
• Do not store TEMPDB database files on Redundant Array of Independent Disks (RAID 5, (RAID 1, 0+1, or 10 is preferred).
• Do not store the Microsoft Dynamics AX transaction log file on RAID 5 (RAID 1, 0+1, or 10 is preferred).
• Do not store Microsoft Dynamics AX data files on RAID 5 (RAID 0+1, or 10 is preferred).
• Store TEMPDB database files on a separate physical store from the user database files.
• Store other database files (if any, such as databases for performance monitoring) on a separate physical store from the Microsoft Dynamics AX 2012 OLTP database files and TEMPDB database files.

For maximum performance configure the database server shown in the following example:

• Two disk RAID 1 for the operating system and database software
• A small, four disk RAID 0+1, or two disk RAID 1 for database logs
• A larger RAID 0+1 for the main database files