Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

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?
0
ccwestbrook
Asked:
ccwestbrook
  • 2
  • 2
2 Solutions
 
tigin44Commented:
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
0
 
pcelbaCommented:
The bottleneck will be the RAID5. Then, from speed point of view, it is not relevant if you use RAID 10 or two mirrors. I would use two mirrors as physically separated storages.
0
 
ccwestbrookAuthor Commented:
What about using multiple RAID 1 volumes instead of RAID 5 or RAID 10 for the data files?
0
 
tigin44Commented:
In my site I prefer using raid 1+0 for data files..
0
 
ccwestbrookAuthor Commented:
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.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now