SQL Server configuration

We strongly recommend configuring SQL Server for optimum performance.

• Place database transaction log files (for all user databases) on a separate set of disks from the database data files. It is preferable to use RAID 1 for the transaction log files rather than RAID 5, for performance reasons.

• Ensure that Tempdb has an adequate size. In addition, Tempdb can be placed on its own disk(s) for optimum performance.