I'm building a brand new SQL Server to run Windows Server 2003 Enterprise 64-bit and SQL 2005. It only purpose it to power out installation of Microsoft CRM. The goal is to achieve maximum performance. The server it will run on is a Power Edge 2950. 8(qty) 146 GB 10K SAS drives. 16 BG of RAM and I'll add more if needed. Procs are dual Quad-Core 2.5 GHz bus speed of 1333 MHz and 12 MB L2 cache.
I've been researching the optimal configuration for performance and as you can imagine, I've seen conflicting statements. Can you offer some suggestions? Should the OS be on a RAID 1 with the DB's on a raid 10 and the Logs on a RAID 1? Or should the 8 drives be put in a RAID 10 and just partitioned out? Is 16 GB of RAM enough? Thanks in advance for the input.