sql server best practices: disk configuration

• store the data and the log on different physical drives
• use the appropriate RAID level depending on the importance of performance and redundancy
• performance only - RAID 0
• redundancy only - RAID 1
• performance and redundancy - RAID 5 or RAID 10
• place files on subsystem connected to different controllers
• mirror the transaction log
• mirror the master and model system databases
• stripe the tempdb database
• store the user database files on a different physical drive from the master , model and tempdb system databases
• monitor the default filegroup or allow for automatic growth
• RAID, SAN and NAS appear as driver letters
• use direct-connected hard drivers or SAN instead of NAS or network file shares
• use NTFS