SQL Server Performance

How to Optimize SQL server performance with SAN

Discussion in 'SQL Server 2008 Performance Tuning for DBAs' started by sachinonnet, Oct 3, 2012.

  1. sachinonnet New Member


    We are running SQL Server 2008 R2 64Bit , enterprise with SP1, for Storage we are using SAN.

    We are facing performance issue with IO below is the configuration:
    1. Two LUN's created for DB Logs and DB Data
    2. Major 5 tables hold 600million rows and partitioned monthly
    3. Read and Write happening 50-50
    4. Partitioned tables don't have cluster index to improve write performance.
    5. 32 CPU coarse where as utilisation shows 1-5%Max
    6. 'max degree of parallelism' currently set to 4

    below are the some changes we suggest and like to know your inputs to improve performance

    1. Create More LUN's for Logs and Data
    2. 'max degree of parallelism' set to 32
    3. Move partitioned index to seperate LUN´╗┐

  2. sachinonnet New Member

Share This Page