What's the best hard drive configuration for SQL 2005 performance?

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.
ammexitAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Paul TozerCommented:
OS Raid 1, Database Raid 10 (0+1), Logs Raid 1 (or 0+1 if you have a lot of transactions and need more disks).

CRM is a heavy load on SQL, but depends on how many users for ram size, obviously more is better but should be ok up to about 100 users but depends on load.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ammexitAuthor Commented:
Right now we have 100 users running on a Dell PowerEdge 2900 with 8 GB of RAM.  We have a large amount of slowdown.  Its only running SQL 2000, so its being limited to 2 GB.  Apparently this is causing the server to use the disks as RAM thus creating the slowdown.
0
Paul TozerCommented:
I take it you are running CRM 3 and not 4 then. Should be much quicker with SQL 2005. Paging to disk will dramatically slow the system down.
0
ammexitAuthor Commented:
Yes, CRM 3.  Is there a performance improvement in 4?
0
Paul TozerCommented:
There are improvements, however I would wait until they have released a version fully compatible with SQL 2008
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.