Maybe I can't put together a query that finds what I am looking for on the Internet, but I want to make sure this is done right.
I have a new server that has Windows Server 2008 R2 loaded onto a RAID 1 configuration. I need to install SQL Server 2008 R2 to take advantage of a RAID 1+0 (10) configuration I also have on this server. I understand these basics:
- Host the database (mdf) files on the data array (the RAID 10 partition)
- Host the log (ldf) files on the OS array (the RAID 1 partition)
What I need help clarifying is the actual install of SQL Server. For example, should I place the Program Files on the data array? Should I put the names instance on the data array? If not, what are the best practices for the actual INSTALL of SQL Server? The rest I can readily search through Google.
If anyone has any advice, direction, or resources here, I would really appreciate it. Thanks in advance!