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
  2. Luis Martin Moderator

  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.
  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.
  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?
  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.

Share This Page