Hardware Suggestion - Needed
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Hardware Suggestion - Needed

Hybrid View

  1. #1
    Join Date
    Sep 2003
    Posts
    49

    Hardware Suggestion - Needed

    we are in the process of migrating 1TB of mainframe data to oracle DB.

    Planning migrate to solaris server.(oracle 10g)


    1) Server model & name (we prefer Solaris box)
    2) No of CPus to handle 1TB of data
    3) Physical RAM (memory)
    4) Storage Array (Disk space)
    5) what kind of RAID level can i use in oracle db.


    Additional info: around 2000 users are going to use oracle db and 750 are concurrent users on

    this database.

    can you kindly suggest suitable hardware for above requirement.

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    You know, that's kind of a tough question to answer... Is money no object? If so I could come up with a good "wish list".

    There's plenty of servers out there that can handle 1T it's just a question of how much money do you want to spend for performance.

    *DROOL*
    Last edited by OracleDoc; 07-27-2004 at 04:49 AM.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    Sep 2003
    Posts
    49
    we need to get good performance. Money no problem.
    What about EMC storage solutions?
    can i choose solaris rather than IBM RS/6000

  4. #4
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Sun has gotten into bed with EMC here lately because HP dropped them for storage systems. HP was EMC's pimary means for selling storage for open systems so I guess they're hurting now. If you're wanting to go with an EMC type storage, as of June 1st Sun rolled out several storage arrays utilizing EMC tech. The two main storage systems that Sun rolled out are the StorEdge 3511 FC and StorEdge 6920 array.

    As far as Servers go what's your growth potential? Right now a V880 may suit you, but a year down the road who knows you may need a K15.

    For Raid, definately go with 0+1 and if you can get some solid states... put your Temp and redos on them and anything else that's getting written to heavily.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  5. #5
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150
    With the number of users you mentioned I suggest that you go for 9i RAC or GRID in 10g. I'm not sure whether 10g is mature enough to be db of choice.

  6. #6
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    In our lab test, no sun server comes to close performance of IBM P 690.

    You can very well go for IBM P 690 with EMC DMX 3000.

    ) Server model & name (I prefer IBM box)
    2) No of CPus to handle 1TB of data - 16
    3) Physical RAM (memory) - 32 GB
    4) Storage Array (Disk space) - DMX 3000 with 32 GB DISK CACHE
    5) what kind of RAID level can i use in oracle db. - RAID 1+0


    Tamil

  7. #7
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    I have a question here. Any workshop with 1TB production data will surely have more than 1 box. Would it be advisable to use SAN that supports both production and test/development environments?
    Sridhar R Patnam

  8. #8
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Of course, yes.
    Money plays importanat role here.
    For 1 TB DB, you need to plan a lot well in advance.

    Tamil

  9. #9
    Join Date
    Sep 2003
    Posts
    49
    Dear Tamil
    you mentioned 16 cpus and 32GB of RAM for 1TB of data.Could you please let me know how did you arrive this ?
    Is there any formula/calcuation for choosing the hardware for oracle database.Kindly give me suggestions regarding this.
    If you don't mind, can you please give me email id of yours?

    Regards
    Saravanabhavan Linganathan (Sarov)

  10. #10
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Since you env is going to be big, You can easily ask SUN, IBM and HP to lend their machines for benchmarking. That is what we do before buy anything.
    Choose the machine based on cost/performance ratio.
    Deciding a HW is not a easy job. You need to know much more about the machine architect, company, support, available tech guys in your location.

    Tamil

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