Let's pretend that I'm building a completely new rig for my main ERP SQL database. I am a systems administrator by trade, so I am a novice when it comes to DB related setups. The database is 30GB and serves 60 users. I would say that the Read/Write ratio is 80/20. The database is accessed by the ERP application as well as Crystal reports that can pull up to a couple million records. Available Hardware: Motherboards Super Micro X8DTi-LN4f with 2 Intel Xeon X5570 Processors and 24GB DDR3 1300 Tyan S2932 with 2 AMD Opteron 2224 Processors and 4GB DDR2 667 (Can buy/add more DIMMs) RAID Controllers Adaptec 3805 Adeptec 5805 SAS Drives 4 146GB 15K 12 73GB 15K OS Windows 2003 Standard Windows 2003 Standard x64 SQL SQL 2000 Standard SQL 2000 Enterprise Limitations Case Backplanes support 8 drives total ERP application only supports SQL 2000. What RAID configuration would you use for best performance? RAID type? Stripe Size? Partition Cluster Size? If we add memory to the Tyan motherboard, would the Super Micro be overkill? If we have more memory than the size of our database, doesn't that mean that the whole database would eventually reside in the cache? So if you were me, exactly how would you set this up given the available resources? Thank you so much for any advice.