I know this question might be too broad, if EE could shed some light, that would be great.
We have a potential client that will have over million records with about 200 fields of data, and each record has thousands of comments associate to that record. What they need us to do is load them in and do some data analysis. My boss asked me to come up with a server quote. Our hardware 99% are from Lenovo, so I will stay with them.
Here is what I am thinking so far:
0. ThinkServer RD640
1. CPU : need help from EE
2. 16G RAM
3. RAID 5
4. OS: Win 2012 STD (we have 2008 domain controller, does it matter?)
5. SQL server STD 2012
Please let me know. thx