SQL Server Performance

sql setup best practice

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by groucho, Jan 16, 2007.

  1. groucho New Member

    Hi everyone

    I have a new dell poweredge 2950 with 8 GB memory
    it has a single raid 5/i card and 6 36GB drives
    I plan on installing windows 2003 standard and sql 2005.

    What is the best raid configuration for this server?
    Do I create a mirror for the OS and a raid 5 for the logs and dat?
    What size clusters should I use for the data?
    Do I use write through on the raid controller?
    Do I setup a pae on the server memory? use a /3gb swithc

    any help would be greatly appreciated...

    cheers
    Barry
    groucho, Jan 16, 2007
    #2

  2. Luis Martin Moderator

    Luis Martin, Jan 16, 2007
    #2

  3. satya Moderator

    How big is the database and how many users are connected in a peak time, also specify the growth for next 3 to 5 years.

    Satya SKJ
    Microsoft SQL Server MVP
    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.
    satya, Jan 18, 2007
    #2

  4. satya Moderator

    How big is the database and how many users are connected in a peak time, also specify the growth for next 3 to 5 years.

    Satya SKJ
    Microsoft SQL Server MVP
    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.
    satya, Jan 18, 2007
    #2

  5. mcosy New Member

    HI,

    I'm also planning to install server thought of buying ML370 G5 quad processor.

    I got 45GB, 25GB and few 5-10GB Databases. and Number of connection says 267 ( actual users are around 100) but growth % for 45GB is 7% and 25GB is 26% ? and others 5-10%?

    And i got all the above questions too?
    mcosy, Feb 22, 2007
    #2

  6. mcosy New Member

    sorry this server can hold 8 x SAS drive and also can add another controller and 8 SAS drive if you need to expand.
    mcosy, Feb 22, 2007
    #2

Share This Page