SQL Server Performance

SQL2K5 server setup

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by waqar, Mar 21, 2006.

  1. waqar Member

    Hi,

    As per Joe earlier advise, I am thinking to go ahead with setup of

    SQL2K5.

    PowerEdge 2850
    2x73Gx10K RPM (OS/SQL/TEMP DB) - RAID 1 (76GB)
    2x36Gx15K RPM (Log files for active DB) - RAID 1 (36GB)

    PoweValut220
    10x146Gx10K RPM (Database files) - RAID 10 (usable 730GB).
    (The reason for me to go for 146 is size increment- today we have about 200GB image database, which is going to be triple in coming 1-2 years.)

    Just to highlight here, I have 2 databases. 1 database is actively used and other database is only use to store and extract images (these images are already stored and user will only view or download these images). This is the reason I am trying to put LOG file of active database to Separate Array and not of database with images.

    I wanted to make a big RAID 10 to create space of 730GB over 10 SCSI Drives.

    Now my question is
    -> Do I put 2 Raid cards, one with 2 internal channels and other with 2 external channels?
    -> Attach my PowerValut with 1 external Channel (as there will be only Single Raid 10)?
    -> Connect both internal RAID 1 to different Channels?

    This will be my first time for setting up such a huge database system, I will appreciate some comments.

    Yah another thing, this Web site don't have huge data entry process. Mainly is query oriented system not data entry oriented, user will see information about listing and do bidding (some thing like eBay). As this is not data entry process and is not write intensive process, do I go with RAID 5 or RAID 10?

    Regards,
    Waqar.

  2. satya Moderator

    Based on the input on the application usage I would go with RAID5, which is suitable.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. waqar Member

    Hi Satya,

    Is there any rule of thumb to identify if one must use RAID 5 based on number of write to database?
    e.g.; 100 Read / 10 Write?


  4. satya Moderator

Share This Page