Home » Developer & Programmer » Data Integration » Server sizing for data warehouse database
Server sizing for data warehouse database [message #93328] Wed, 14 July 2004 11:44 Go to next message
Chuck Shores
Messages: 1
Registered: July 2004
Junior Member
How can I figure out how many GHz of processor power would be required on a 64-bit RISC platform (specifically Sun) to support a planned data warehouse application with the following characteristics:

2000 registered users, 200 max active

2 terabytes of data

50/50 mix of canned reports and ad hoc queries
Re: Server sizing for data warehouse database [message #93334 is a reply to message #93328] Wed, 21 July 2004 10:04 Go to previous messageGo to next message
Fafa Boom
Messages: 1
Registered: July 2004
Junior Member
My goodness - this sure is boring...
Re: Server sizing for data warehouse database [message #93378 is a reply to message #93328] Mon, 04 October 2004 14:08 Go to previous message
Mike
Messages: 417
Registered: September 1998
Senior Member
that totaly depends on how good the desing of your DWH has been done and how you/your developers use all the DWH features provided by Oracle.

Because you probably don't know what kind of queries the end users are going to execute nor which marts will exists and how they are designed it's realy hard to make any estimation.

I would recomand you to begin with a sun fire12k 20 CPUs and about 40G Ram. In case that shouldn't be enought you can still upgrade it to over 50 CPUs and almost 300G Ram.

Good luck
Mike

PS: what is your definition of an ACTIVE user?
Previous Topic: Fact table partition problems
Next Topic: Help/Suggestions Needed : Data migration using Oracle warehouse builder.
Goto Forum:
  


Current Time: Mon Aug 03 05:15:54 CDT 2020