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