Dear all If we have a server with  hard disks,and If we made  hards RAID 1+0 (c:) what is the best practice for the other hard disks (6) for SQL Server. 3 hard disks (d:) RAID 1+0 , 3 Hard disks(e:) RAID 1+0 install SQL on C: put the data file on d: and T-log on e: any Idea
It all depends on your I/O requirement. Best practice is to separate your data files and log files due to sequential vs random I/O, however if you are going to have multiple log files on the same drive then your sequential writes become more random. It all comes down to speed, size and protection that you are going for. I would personally go with a RAID 1 for C: and then RAID 6 for the secondary drive. SQL on C and Data and Logs on D. Again though, it depends on the work load, size of the data, etc.