CFD Online Logo CFD Online URL
www.cfd-online.com
[Sponsors]
Home > Forums > General Forums > Hardware

Database Workstation

Register Blogs Members List Search Today's Posts Mark Forums Read

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old   September 15, 2016, 10:37
Question Database Workstation
  #1
New Member
 
Jackson Samuel
Join Date: Sep 2016
Posts: 1
Rep Power: 0
ojesus2006@gmail.com is on a distinguished road
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.
ojesus2006@gmail.com is offline   Reply With Quote

Old   September 15, 2016, 12:38
Default
  #2
Super Moderator
 
flotus1's Avatar
 
Alex
Join Date: Jun 2012
Location: Germany
Posts: 3,427
Rep Power: 49
flotus1 has a spectacular aura aboutflotus1 has a spectacular aura about
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.
flotus1 is offline   Reply With Quote

Reply

Tags
database, processor, server, system, workstation

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


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


All times are GMT -4. The time now is 16:54.