Friday, March 9, 2012

Hardware configuration

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,

I'd say definitely option 2

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

|||

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.

No comments:

Post a Comment