[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Server Recommendations

Posted on 2005-04-19
Medium Priority
Last Modified: 2010-04-26
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
Question by:Marcusw
LVL 13

Accepted Solution

eatmeimadanish earned 1000 total points
ID: 13819112
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.

Expert Comment

ID: 13819308
Yup ..your gona want super HD acess times ...and ram is always good for serching . I would agree


Expert Comment

ID: 13820229
tyan make some nice server boards


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

Author Comment

ID: 13823851
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
LVL 13

Expert Comment

ID: 13828749
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).  

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

A clone is a duplicate copy. Sheep have been cloned and maybe someday even people will be cloned, but disk cloning (performed by the hard drive cloning software) is a vital tool used to manage and protect data. Let’s look at what hard drive cloning …
New style of hardware planning for Microsoft Exchange server.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month18 days, 20 hours left to enroll

834 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