Database Server hardware specs

Hi all,

We have system for our work that uses a web/application server and a database server. Around 150 people use this application and the data stored are usually text, ms office documents, pdf files and images. Suppose that about 50 people are using the system at any given time, what do you think will need better hardware specs, the database server or the web/application server?

Could you give any recommendations for the hardware specs? Like cpu, ram? A friend of mine suggested that it would be good to use the nVidia Tesla GPU for parallel processing. Is this a good idea or is this going a bit overboard?

Thanks :)
5 answers Last reply
More about database server hardware specs
  1. Hi :)

    Specs of current system ?

    All the best Brett :)
  2. Hi :)

    Oops forgot to add..you realise Teslas cost THOUSANDS >?

    All the best Brett :)
  3. efreet said:
    Hi all,

    We have system for our work that uses a web/application server and a database server. Around 150 people use this application and the data stored are usually text, ms office documents, pdf files and images. Suppose that about 50 people are using the system at any given time, what do you think will need better hardware specs, the database server or the web/application server?

    Could you give any recommendations for the hardware specs? Like cpu, ram? A friend of mine suggested that it would be good to use the nVidia Tesla GPU for parallel processing. Is this a good idea or is this going a bit overboard?

    Thanks :)



    What applications are you running exactly (SQL, Oracle, Sharepoint, etc.), what are your planed uses beyond a web server, and what are your plans for future expansion, if any. Knowing your budget would also be nice, case in point, this is what we use as a database server (a couple actually), but they are quite expensive (~$9000) and probably beyond your budget.


    PowerEdge R710 Chassis for Up to 6, 3.5-Inch Hard Drives

    Processor Intel® Xeon® E5649 2.53GHz, 12M Cache, 5.86 GT/s QPI, 6C
    Memory 32GB Memory (8x4GB), 1333MHz Dual Ranked LV RDIMMs for 2 Processors, Advanced ECC
    Additional Processor Intel® Xeon® E5649 2.53GHz, 12M Cache, 5.86 GT/s QPI, 6C
    Operating System Windows Server 2008 R2 SP1, Standard Edition, Includes 5 CALS
    OS Media kits Windows Server®2008SP2 STD ED,x86/x64,DGRD MED f/WS2008R2SP1 ENT,DATACTR
    Hard Drive Configuration RAID 5 for H700 or PERC 6/i Controllers
    Internal Controller PERC H700 Integrated RAID Controller, 1GB NV Cache, x6
    Hard Drives 6x 300GB 15K RPM SAS 6Gbps 3.5in Hot-plug Hard Drive
    Power Supply High Output Power Supply, Redundant, 870W
    Power Cords NEMA 5-15P to C13 Wall Plug, 125 Volt, 15 AMP, 10 Feet (3m), Power Cord
    Power Cords 2x 10 feet (3m) Power Cords, 125 volt 15 AMP NEMA 5-15P to C13 Wall Plug
    Embedded Management iDRAC6 Express
    Network Adapter 2x Intel Gigabit ET Dual Port NIC, PCIe-4
    Rails ReadyRails™ Sliding Rails With Cable Management Arm
    Bezel Bezel
    Internal Optical Drive DVD ROM, SATA, Internal
    Server Accessories 2U Threaded Hole Rack Adapter Kit for Sliding ReadyRails™
    System Documentation Electronic System Documentation and OpenManage DVD Kit
    Media Internal SD Module with 1GB SD Card
    Feature Upgrades for Embedded NIC Ports Embedded NICs are TOE Ready with iSCSI Offload Enabled
    BIOS Setting Performance BIOS Setting
    Riser Card Riser with 2 PCIe x8 + 2 PCIe x4 Slot
    Asset Tag on System Chassis (CFI) System Box Label
    Hardware Support Services 3 Year ProSupport and Mission Critical 4HR 7x24 Onsite Pack
  4. sk1939 said:
    What applications are you running exactly (SQL, Oracle, Sharepoint, etc.), what are your planed uses beyond a web server, and what are your plans for future expansion, if any. Knowing your budget would also be nice, case in point, this is what we use as a database server (a couple actually), but they are quite expensive (~$9000) and probably beyond your budget.


    Thanks sk1939 :)

    The database is MS SQL and there is no plan to use it for anything else. So I guess it is the database server that should be geared for high performance. How about the nVidia Tesla GPU, is that a good idea? Our budget is around $6000.

    Hi Brett928S2 :)

    The current system is Xeon 3 GHz, two cores with 4GB RAM on RAID 1. I guess Tesla GPU would be more useful on the application server, is it? According to nVidia site, the lower end ones are around $2500. But is this worth it?

    http://www.nvidia.com/object/io_1258360868914.html
  5. efreet said:
    Thanks sk1939 :)

    The database is MS SQL and there is no plan to use it for anything else. So I guess it is the database server that should be geared for high performance. How about the nVidia Tesla GPU, is that a good idea? Our budget is around $6000.

    Hi Brett928S2 :)

    The current system is Xeon 3 GHz, two cores with 4GB RAM on RAID 1. I guess Tesla GPU would be more useful on the application server, is it? According to nVidia site, the lower end ones are around $2500. But is this worth it?

    http://www.nvidia.com/object/io_1258360868914.html



    MySQL is a relatively easy load, but at the same time I would not put it on the same physical server (virtualized) as others. This would be a good server to use for a database server, and would provide ample room for expansion. As far as a Tesla, it would provide lots of power for crunching numbers, but I don't thing it would have much in terms of gain for a database server.
Ask a new question

Read More

Hardware Servers Database Components