Server Recommendations

i have been give the task to purchase a new server.

this server will need to count frequently 15 million records on a database that is about 40gb and give back answers in no more that 5 secords

i have been told that i should be looking at at least a 4cpu system, but i am struggling to find one under £10,000

i am also sturggling to find anybody that sells server parts as i thought this might be a cheaper option.

any suggestions or starting points would be very helpful
MarcuswAsked:
Who is Participating?
 
eatmeimadanishConnect With a Mentor Commented:
Let's think through this process.  You have data that needs access across a network and you need this data promptly.  With 15 million records I am going to assume you are using a SQL server.  I hope to God you are.   Your biggest bottleneck will be your Hard Drive access time.  This is a list I would look at as priority.

1) RAID 5 or 10 setup for speed and redundancy. You can do this with SATA or SCSI.
2) Lots of RAM (at least 2gb)
3) A good cpu is better then more CPU.  SO get the best CPU you can and you can a skimp on the 4-way.  2 proc should work fine.
4) Another problem is that people get these awesome servers and then only use one network card.  Utilize load balancing on multiple nics.  This will up your throughput and keep up with your demand.


The rest you can just look for reviews or complete packages.  I like building these myself, but sometimes its easier to just get built to go boxes.
0
 
RimscorpCommented:
Yup ..your gona want super HD acess times ...and ram is always good for serching . I would agree



                                                                                                                  -James
0
 
gjohnson99Commented:
tyan make some nice server boards

www.tyan.com   

They make 2 and 4 Cpu Amd 64 bit borads, that should take the new Amd dual cores just being released

They also suport Pc-Express slots
0
 
MarcuswAuthor Commented:
thanks for all  your input,

does anybody have any suggestions as where to find either parts or a complete system

is there a big differance between the amd and intel, i've been told to get xeon but there are two types

whats the difference
0
 
eatmeimadanishCommented:
Opteron is awesome.  And gets you ready for the 64bit push.  Check out www.tomshardware.com or www.anandtech.com for guides to Motherboards.  I buy everything from www.newegg.com.  Though you may also want to consider a package deal with Dell.  Unfortunatly you are stuck with the p4 or xeon (overly expensive).  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.