mcrmg
asked on
SQL Server specs
Hi,
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you very much..
ASKER
>>I know, sorry about that, that's the basic info I have, so is my boss
CPU: the more, the better, normally. I would rather start with a 4-CPU box.
>>It looks like Lenovo ThinkServer RD640 does not support 4 CPU (maybe I was wrong)
will data be added? or just fully reloaded each time
>> The data will be loaded once, and once only, there is no monthly data after that
typically, especially as this would not be a domain member, but a domain controller/sbs server.
>>Is it possible that you could explain more on this?
thank you