Post reply

best h/w for this sql svr db

  • May 2, 2007 at 1:09 pm

    #116582

    Hi all,
     
    I was wondering if anyone had any thoughts on the following:
     
    My organization is thinking of moving from an old version of a Kana email mgt software product (Response, 7.0)
    to a newer version (Response, 9.1).
     
    We are lucky in that we can start with an empty database; nothing has to be brought over to the SQL Svr 2000 db that we will set up use for the app's backend,
    to replace the Oracle db we are currently using with Kana.
     
    The server which which houses our production db for the Kana application is currrently a Sun Microsystems E450 server with 3 X UltraSPARC-II 400 MHz processors, w/ RAM of 2 GB,  1 RAID, and a Sun OS 5.7.  The drive type used is SCSI.
     
    My Oracle dba suggested we'd need about 20 GB of disk space for the new SQL Svr db we set up. This db will house about 7 months of data (emails), and
    previously the Oracle db housed 12 months + of data using 24GB.
     
    Any thoughts / opinions on the server hardware optimal for this type of SQL Svr db, including RAM, RAID, disk space, etc, is hugely appreciated.
     
    (We are thinking of a Windows 2003 svr.)
     
    Thanks in advance!

  • May 3, 2007 at 8:57 am

    #704103

    Here is a rack mounted solution:

    HP DL-380 G5

    I thas Dual 3 Gh Xeon processors, 2 Gb RAM and uses only 1/3 of the previous generations power and cooling.

    Add 6 10K 36 Gb disks (they are mini disks so 15K are not available). Use 2 in a RAID 1 for the OS, page file and application software. As for the other 4 disks, you can either do 2 more RAID 1's or create a RAID 5 with a hot spare.

    Your cost is somewhere in the 7-8K range.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply