Link to home
Start Free TrialLog in
Avatar of ccwestbrook
ccwestbrookFlag for United States of America

asked on

SQL Server 2008 Hard drive considerations

Hi,

I'm going to be setting up a new server soon and I have two choices to consider regarding the hard drive configuration.   For the data files, I need to use a RAID 5 array.  For the operating system and transaction log, I can either set up two separate mirrored volumes (one for OS and one for TL), or a RAID 10 volume for the both of them to occupy.  Suggestions?
Avatar of tigin44
tigin44
Flag of Türkiye image

it should be better that you plan different disks for os, data, log and temp
data disk should be raid 5 or raid 1+0 depending on your need and write performance..
log and temp disks should be raid 1
os disks depends on your hardware possible raid 1 or raid 1+0
ASKER CERTIFIED SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ccwestbrook

ASKER

What about using multiple RAID 1 volumes instead of RAID 5 or RAID 10 for the data files?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for the input.  I am going to go with a 6 disk RAID 10 volume for the data files, and two mirrored volumes for TL and OS.