I need to purchase an ETL machine for conversions. The software will have MS SQL 2008, Monarch, and Pervasive SQL running on it. 3.5 processor and 32 gb of ram. For hard drives I have three choices,
1. 4 SATA SSD 6 gb in a raid 10
2. 2 SSD SAS 12 gb in a raid 1
3. 2 SATA SSD 6 gb in raid 1 AND 1 iofusion IOFX pci card
My question, what is faster? This machine will not service clients, it's only for one time operations routinely. I am buying a Dell Precision, so I don't really know the specific drives, other than the description it says online. Or, are there any alternatives that I can do for about the same cost (8k)? I cannot do 4 SSD SAS in Raid 10 due to budget constraints.