Server Machine
|
The following list outlines the recommendations for your Server Machine setup.
- Use the Windows Server operating system.
- Configure the server as a ‘member’ server — not a domain controller.
- Dedicate the server to SQL Server and do not use it to run any other applications, especially Exchange.
- The disk subsystem should use hardware-based RAID (not software Raid).
- SQL Log files should reside on either RAID 1 (mirror) or RAID 0+1, which are the best options for sequential write activity of SQL Log files.
- SQL Data files should reside on either RAID 5 or RAID 0+1, which are the best options for the random access activity of SQL Data files. If the write activity is greater than 10%, then use RAID 0+1 instead of RAID 5.
|
