Raid 10

February 7, 2010 at 00:14:28
Specs: Windows 7
I just got a San for work. Its using Fiber. Im going to be clustering alot of SQL servers and also create a LUN for my Images for my Hyper v Machines. What is the best way to setup my san and also create a raid 10. How many disks should I use for optimal performance for raid 10?

See More: Raid 10

Report •

February 8, 2010 at 07:51:57
I think you need a minimum of 4 drives for RAID 1+0. Now I am not sure about your question, are you looking to setup RAID 1+0 in each of your SANs units or are you looking to setup RAID 1+0 with the SANs them selves? The later is harder and risky so I would stick with RAID within the SANs units.

As for performance RAID 0 is the fastest but it has NO fault tolerance. RAID 1 is slow and halves your disk space but has the highest (50% loss) fault tolerance. Every thing else is in between being that the closer you move to fault tolerance the slower the performance and vice-verse. This is where RAID 1+0 comes in because it uses a set of parity drives to get the best of both worlds. Not sure if that answers your question.

Also, I would steer clear of Hyper-V right now unless you have a Microsoft Consultant to help you. It is not support by all BIOS and you might find it cheaper to go with a Citrix Xen server instead.

P.S. Why are you looking to put your live data on a SANS unit as apposed to local drives on the SQL server?

Performance of a network drive will never match that of local drives.

Is it for security reasons to make sure your data does not reside locally in-case the box gets hacked?

Or, are you planning on setting up more than one SQL server box which will access the same SANS?

Report •

February 8, 2010 at 10:04:39
Im setting up 12 new servers and using the san for all the hyper v machines. Alot of the servers will be sql and I will be clusterting them.

Report •
Related Solutions

Ask Question