SQL Server Performance

New SQL Server Hardware Configuration

Discussion in 'Performance Tuning for Hardware Configurations' started by mcosy, Sep 20, 2007.

  1. mcosy New Member

    HI Guys,
    Finally i'm going to buy this new Server and SAN for my company but got few questions and please advise
    1. DS3400 can hold 12 HDD so can i go with 300GB x 12 or 146 x 6 and 300 x 6?
    2. How do we backup SAN, If this SAN failed?
    3. How we create the RAID on this SAN?
    4. Can performance degrade if use this SAN for Windows DFS share?

    Main SQL Server - Dual CPU, 8GB Ram, 2x 73GB HDD, 3x Nics, 2x HBA, RSA II, 8K, Red Power
    x3650, Xeon Quad Core X5355 120W 2.66GHz/1333MHz/2x4MB L2, 2x1GB ChK, O/Bay 3.5in HS SAS, SR 8k-l, CD-RW/DVD Combo, 835W p/s, Rack 1
    Intel Xeon Quad Core Processor Model X5355 120w 2.66GHz/1333MHz/8MB L2 1
    2GB (2x1GB) PC2-5300 CL5 ECC DDR2 Chipkill FBDIMM Memory Kit 3
    IBM 73GB 3.5in 15K HS SAS HDD 2
    ServeRAID-8k Adapter 1
    QLogic 4Gb FC Single-Port PCIe HBA for IBM System x 2
    Remote Supervisor Adapter II Slimline 1
    NetXtreme 1000 E Single-Port PCI-E 1GbE 1
    xSeries 835W Redundant Power Option 1
    IBM SlimLine USB Portable Diskette Drive 1
    3 Year Onsite Repair 24x7 4 Hour Response 1
    3650 Enahnced Hardware + NOS Install (IBM) (Windows 2003) 1

    IBM System Storage DS3400 Dual Controller (Non Biddable - Std price is $11499.00ex - Promo ends 30/09/07. Once promo ends, it will be std price) 1
    DS3000 1GB Cache Memory Upgrade (Non Biddable) 2
    IBM 146GB 15K 3.5in HS SAS HDD 6
    IBM 300GB 3.5in 15K HS SAS HDD 6
    IBM 4-Gbps Optical Transceiver - SFP (Non Biddable - Std price is $167ex - Promo ends 30/09/07. Once promo ends, it will be std price) 4
    DS3000 FlashCopy Expansion License (Non Biddable) 1
    DS3400 Software Feature Pack (Non Biddable) 1
    5m Fiber Optic Cable LC-LC 8
    3 Year Onsite Repair 24x7 4 Hour Response 1
    Install DS3000 and 2 Host Servers No EXP's 1
  2. Luis Martin Moderator

    Check:
    http://sql-server-performance.com/Community/forums/t/2337.aspx
    and wait for Joe opinion.
  3. bradmcgehee New Member

    If you want ideal IO performance, go for more disks than less disks, assuming your SAN is able to handle the throughput of multiple disks. Many of the questions you asked are SAN specific, and I suggest you contact your SAN vendor for answers to your questions.

Share This Page