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
