Which setup is best

Posted on 2005-04-21
Last Modified: 2010-04-26
i am about to purchase a server

i have been offered 2 deals in my budget that sound good but i do not know which is the better option.

either a quad MB with 4 2.0ghz xeon processos or a dual MB with 2 3.4xeon processors

the rest should be mostly the same with
2x 36gb 15000rpm HDD
3x 72gb 15000rpm HDD
8gb Ram

it is purley for counting millions of records on an SQL SERVER 2000 database

which would be fastest?
Question by:Marcusw
    LVL 12

    Accepted Solution

    which is better depends on your load.

    I would go with the 2 processor version for a few reasons:

    1) Any software licensed "per CPU" will be half the cost
    2) Many times a single process using a single cpu is what holds things up, while the other CPU's sit idle - for that reason faster CPU's make more sense.

    - Jack
    LVL 8

    Expert Comment

    A great deal of what will help with the decision is weather or not the programs have dual processor ability. In other words can you tell task A to use cpu B, and task B to use CPU A.

    Siice it will be a SQL 20000 DB sever the 2 processor should be more then enouogh. If I am not mistaken you can use one cpu to count and another running a different set of prcoesses maked it more effiecent. Al though SQL2K and efficent is an oxymoron.
    LVL 6

    Expert Comment

    hi marcusw,

    You won't be able to use all the ram - i386/windows has a 3Gb allocation limit to a single process - but even this needs to be enabled by adding a /3Gb switch to the end of the selection line in boot.ini.
    thus 4Gb of physical RAM should be heaps.

    I would opt for the quad processors then allocate 3 processors to SQL server for SMP.. one processor left for system / kernel processes.. should be fine for what you want.

    LVL 6

    Expert Comment

    I agree with long as your database will give you the option to allocating to another processor, then I would get the quad processor so that you can have it doing various tasks at the same time.  I have seen this live & you should be impressed.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Hello to users to the new age of computers. There are so many products to choose from nowadays that you maybe confused to understand which product is the correct product for you. Let me explain briefly what should be the idea product for your best n…
    Is it worth it to buy an Echo? In a word, yes! For me it was definitely worth it. I use mine on a daily basis. Prologue & Privacy At first, I was very skeptical about the Amazon Echo. In general, I don't like voice assistants. I don't li…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now