To All Warehouse Administrators - Need Advice
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: To All Warehouse Administrators - Need Advice

  1. #1
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    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
    _________________________
    Joe Ramsey
    Senior Database Administrator
    dbaDirect, Inc.
    (877)687-3227

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    We "try" to do a DW, in Windows NT.
    Just an advise:
    DON'T DO IT!!
    :D
    We are planning to change to Sun.
    Ramon Caballero, DBA, rcaballe@yahoo.com

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Go for EMC disk array and Sun E6500.

  5. #5
    Join Date
    Sep 2000
    Posts
    128
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width