Database Server hardware specs

[efreet]

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

 

[Brett928S2]

Hi

Specs of current system ?

All the best Brett

 

[Brett928S2]

Hi

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

All the best Brett

 

[sk1939]

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

 

[efreet]

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

 

[sk1939]

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.