Solved

SQL Server specs

Posted on 2014-03-10
4
287 Views
Last Modified: 2014-03-10
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
0
Comment
Question by:mcrmg
  • 2
  • 2
4 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 350 total points
ID: 39917738
it's difficult to quote if you don't really the requirments ...
with 1 server, you don't have any real backup/redundancy, but let's keep that apart.
CPU: the more, the better, normally. I would rather start with a 4-CPU box.
likewise with  RAM, 16GB ram for a server where you want to do data analysis is just too low, typically, especially as this would not be a domain member, but a domain controller/sbs server.

the number of records and fields alone is not "key", but you need the average row size.
also, what is this "data analsiys about, I presume some denormalized and/or aggregated data, so you need to know a bit about what/how data needs to be crunched.
also, will data be added? or just fully reloaded each time?
0
 

Author Comment

by:mcrmg
ID: 39917763
it's difficult to quote if you don't really the requirments ...
>>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
0
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 350 total points
ID: 39917827
if this is for a one-shot, you might consider renting a machine in the cloud out there instead of setting up a full-blown one on your site ...
or, if this is a kind of tasks your company wants to do regulary, you might want to invest in a VMware solution ...

anyhow, if your rack/server specs allows for 1-CPU models only, it shall also work. if the time is not "crucial", you can just go ahead.

domain controllers (and sbs =small business solution servers are a special "All-In-One" server) need to be really powerful, but this is not your situation, as I understand.
0
 

Author Comment

by:mcrmg
ID: 39917833
thank you very much..
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
HP ML PROLIANT M350P Gen 8 + Virtualisation 5 72
Whether to use true/false, yes/no or 0/1 11 57
mysql ide 10 39
Display images from mysql blob type (Not working) 9 26
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question