|
[Sponsors] |
September 15, 2016, 10:37 |
Database Workstation
|
#1 |
New Member
Jackson Samuel
Join Date: Sep 2016
Posts: 1
Rep Power: 0 |
Hi,
I am looking forward to assemble a workstation for my Database. The basic requirement is Oracle database, Linux. The database size is 7 TB. I wanted a system that can speedily process the data and queries. I planned following system:- Dual Intel Xeon E5-2620 v3 64 GB (16 GB x 4) DDR4 Memory 8 TB (2 x 4 TB WD Re WD4000FYYZ) Intel Dual-P Board S2600CW2R Cooler Master HAF 912 Combat Cooler Master RS750-AMAAG1-UK But still I think the system can be more better per value of amount that I can spend. |
|
September 15, 2016, 12:38 |
|
#2 |
Super Moderator
Alex
Join Date: Jun 2012
Location: Germany
Posts: 3,427
Rep Power: 49 |
I am not an expert on database applications, but I can share my 2 cents:
The Xeon E5-2620 v4 is the current version of the processor you had in mind. it has 2 additional cores and costs about the same as the v3 version. Memory: you get 8 memory channels in total with two of these CPUs so you need 8 DIMMs. 8x8GB will get you the same amount of RAM but more performance in bandwidth-dependent scenarios. Dont forget that you need DDR4-2133 reg ECC. The motherboard you picked has an SSI-EEB form factor which is similar to the E-ATX standard. So you need a case that can hold E-ATX motherboards. As far as I can tell, your current case is only compatible with ATX and smaller form factors. I would recommend the Nanoxia deep silence 5. Similar problem with the PSU: Dual-CPU motherboards need an additional 8-pin EPS power connector that your current PSU doesn't seem to have. I would recommend the Bequiet Dark Power Pro P11 550W for your setup. Now since I am not an expert I can only rely on guesses and second-hand knowledge from here on: Mechanical HDDs might be the bottleneck of your database server. Using SSDs instead should significantly increase performance. However, since you probably can not use consumer SSDs for this application this might turn out to be quite expensive. It will be necessary to discuss this issue with experts in the field of database applications. Maybe it would be even better to use a single-CPU setup and spend the savings on faster I/O devices. |
|
Tags |
database, processor, server, system, workstation |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using database files in OpenFOAM | menonshyam | OpenFOAM Programming & Development | 3 | August 16, 2014 16:28 |
Dual cpu workstation VS 2 node cluster single cpu workstation | Verdi | Hardware | 18 | September 2, 2013 04:09 |
Can't open the database. Help Please! | CFX Begineer | CFX | 1 | October 27, 2002 14:08 |
can't open database cfx 5.5.1 | Olivier Macchion | CFX | 4 | October 7, 2002 10:19 |
can't open database | Olivier Macchion | CFX | 0 | September 25, 2002 04:14 |