To All Warehouse Administrators - Need Advice

[wjramsey]

All,

We are looking at HP, Sun, and IBM as possible vendors for our data warehouse platform as DG is marching slowly towards the sunset.

I'd like to hear from those of you out there running a warehouse and see what platform and config you're running on and what the size of your warehouse is. We are currently running on an 8-way DG box w/ 4GB of memory and about a 500GB database. What do you like/dislike about the platform? Basically any information and advice which will help in the selection process.

Thanks!

Joe

__________________
_________________________
Joe Ramsey
Senior Database Administrator
Cintas Corporation
6800 Cintas Blvd
Mason, OH 45050
(513) 573-4167

[marist89]

In my previous company, we ran a 1TB datawarehouse on a Sun E5500 with 6x400 Mhz CPU's and 6GB of RAM. Performance was very acceptable.

[rcaballe]

We "try" to do a DW, in Windows NT.
Just an advise:
DON'T DO IT!!
:D
We are planning to change to Sun.

[tamilselvan]

Go for EMC disk array and Sun E6500.

[TerryD]

All our database are run on Sun machines.
Anything up to E10000 with EMC arrays - CPU's varying from 6 to 52 and memory from 4Gb to about 32Gb+

The database I administer isn't datawarehouse, but I know we have a few running on the same hardware.

It's very quick and very scalable.