I have a server that has a RAID 1 boot drive (2 146GB SAS drives) and a RAID
10 data drive (4 300GB SAS drives). I am installing SQL 2008 and it wants
to default to the boot drive. Should I have it install to the RAID 10
drive? I plan on having the SQL DB located on the RAID 10 drive. I'm
looking for best performance.

Thanks,

John

John (bsmith (AT) aol (DOT) com) writes:
You can configure a different directory for the database files, and
that is a good idea. The executeable can stay on the root disk.

Later when you create the databases, you can always decide which drives
they should go to. You should have data files and log files on different
drives, and you may want to have more than these two files.

Of the system databases, the most important is tempdb. You can always
move it later, and you should probably create multiple files.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thanks for the info, that answered my question!

John
"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote