SQL Server Performance

Best disk configuration

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by grgrr0, Aug 2, 2006.

  1. grgrr0 New Member

    We are moving from a s2k environment to a new server running Windows 2003 server 64bit and S2k5 64bit. The new server is:
    a Dell 1950 with 2 x 3.00Ghz dual core xeon processors 2x2Mb cache
    8Gb memory
    2 x 143Gb 15k disks (internal)
    MD100 with 4 x 73Gb (10k) and 10 x 36Gb (15k) drives
    Perc 5/i
    Perc 5/e

    This will be running just the single Production database (40Gb), which will be replicated to another server, so there is a distribution database as well.

    I am in 2 minds as to which way the disks should be configured, either using Raid10 and partitioning or using Raid 1 pairs and multiple filegroups.

    I would appreciate any advice on what would be the optimal setup for the above hardware.






    Graeme Ross
  2. satya Moderator

    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=15002 what is speaks.

    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.

Share This Page