| Server sizing for data warehouse database [message #93328] |
Wed, 14 July 2004 11:44  |
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 #93378 is a reply to message #93328] |
Mon, 04 October 2004 14:08  |
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
