I am setting up a new MS SQL Server 2005 on a server with Direct Attached Storage SAS (serial attached SCSI) drives. I have a limited number of hard drives to work with. From other posts in Experts Exchange I've learned that
1. c: drive should be mirrored (Raid 1) and can contain the operating system, SQL2005 binaries, log files, and backup files (.trn and .bak).
2. d: drive should be RAID5 and contain the data and index files (.mdf files). I have 4 drives (including the hot spare) for the RAID5.
1. When the RAID5 is created, do I end up setting the chunk size or segment size? What do these terms mean and what are the optimum settings for SQL server 2005.
2. I understand that in RAID5, increasing the number of drives improves performance, but is there something less efficient about having 3 active drives instead of 2; or 4 is worse than 3? I thought I read relating to Oracle that "blocks" were 8k, so you want to split them over 2 or 4 drives, not 3 drives. Is this true for SQL 2005 as well?