Database Workstation

ojesus2006@gmail.com · September 15, 2016, 10:37

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.

flotus1 · September 15, 2016, 12:38

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.

September 15, 2016, 10:37	Database Workstation	#1
ojesus2006@gmail.com 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.

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

September 15, 2016, 12:38		#2
flotus1 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.