locked
Hardware configuration RRS feed

  • Question

  •  

    Hi i'm doing mirroring on 2 servers

    each has 6 disks.

    what is the recommended configuration for each server?

    Option 1:  2 disks (mirror) for OS and 4 disks (RAID5) for SQL

    Option 2: 2 disks (mirror) for OS, 2 disks (mirror) for SQL & Data, 2 disks (mirror) for SQL Logs.

    or maybe other suggestion ? maybe some logical partitions ... (TempDB ...)

     

    thanks, 

     

    Tuesday, November 14, 2006 9:19 AM

Answers

  • It is recommended that you separate log from data and other activities.

    It all depends upon the throughput of your disks and the response requirements of your application.

    Sunday, November 19, 2006 8:00 PM

All replies

  • I'd say definitely option 2

    every article I read suggests log/temp db on separate physical DRIVE (not partition) than data

    Tuesday, November 14, 2006 3:44 PM
  • It is recommended that you separate log from data and other activities.

    It all depends upon the throughput of your disks and the response requirements of your application.

    Sunday, November 19, 2006 8:00 PM