need hlp with sizing

3 posts / 0 new
Last post
orin28
orin28's picture
Offline
Last seen: 1 week 4 days ago
Joined: Feb 24 2013
Junior Boarder

Posts: 5

itamar steinberg
need hlp with sizing

i have 5 dim tables with ~ 1 million rows 

also 2 fact tables with 500 Million rows 

there are joins with those dims and facts - of course aggragations and calculations .  

 

what should be an optimal hardware ? 

do i need more than one server ? how much memory ? cpu ? disks?

would you suggest 1um and 1 pm for later growth? and configure : multiple and seperate?

 

please suggest an option that we can grow with it - add pm's later on 

 

thank you 

 

itamar 

radams
radams's picture
Offline
Last seen: 7 hours 49 min ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
need help with sizing

 

With only a few tables and only 500M rows in the fact tables, a single server is fine.

The more CPU's and RAM the system has will improve the system speed. If  your planning

on having multiple terabytes of data, configure the system with 1UM and 1PM and expand the 

number of PMs as the data size grows.

 

 

Thanks,

 

Robert

 

 

orin28
orin28's picture
Offline
Last seen: 1 week 4 days ago
Joined: Feb 24 2013
Junior Boarder

Posts: 5

itamar steinberg
server size ?

hello ,

 

how many cores we need ?

how much ram? 

 

do you have a benchmark of sizing?

 

thank you