Storage pools vs Raid 10

Tore Jacobsen
Tore Jacobsen used Ask the Experts™
on
Storagepools vs Raid 10.
Hi. We are setting up a physical server (not running Hyper-V) to act as a Domain controller and a SQL server.
Plan is to use 8 x 600GB drives (SAS) sat up in Raid 10 (using onboard Raid controller - HP ML 350 Gen10 server)
Divide in 2 partitions C: for Win 2016 and D: for SQL data.

Not familiar with storagepools.
Is an option to use 2 disks in a mirror (created on raid controller and create a Storage Pool in File manager after windows is installed.
Looking for max r\w but also safety in case of disks crashing.

This setup may also be used for single Hyper-V host as well?

Happy for any suggestions
Thanx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Andrew Hancock (VMware vExpert / EE Fellow)VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017

Commented:
I've prefer "old school" hardware RAID 10  HPE Smart Array controller, easier to repair/restore.

Although why your DC is not virtual is another question ?
Tore JacobsenSystem adminstrator

Author

Commented:
Hi and thanx.
Small 10 user dentist office only using\ needing fast SQL access.
Have also sat ut hyper-V with 2 vm's (DC and SQL) but don't seem to get the same speed as with one physical.
Also question of licenses.
kevinhsiehNetwork Engineer

Commented:
A pair of SDD will be much faster and less expensive than 8 HDD in RAID 10.

Don't use Storage Pools.

You should be running as VMs.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Top Expert 2014

Commented:
Storage Spaces isn't good for fast writes as it has no non-volatile  write cache, So long as you get a model with a storage battery write performance will be good using hardware RAID. Read performance will be similar either way.
Andrew Hancock (VMware vExpert / EE Fellow)VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017

Commented:
This is a DC, not SQL.

A Windows Standard licenses, entitles you to use 2 VMs. (e.g. includes licenses)
Philip ElderTechnical Architect - HA/Compute/Storage

Commented:
Run two VMs as has been suggested.

SQL of any flavour is not supported on a Domain Controller.

I have two very thorough EE articles on all things Hyper-V that are applicable to this situation:

Some Hyper-V Hardware and Software Best Practices
Practical Hyper-V Performance Expectations

Note that a small dentist's office could benefit from the SQL VM being on a pair of SATA SSDs such as the Intel SSD D3-4610 series in RAID 1. There would be more than enough IOPS for that scenario.
Doug BishopDatabase Developer

Commented:
Also, I would NOT put the system drive on the same drives as SQL Server. Also, any flavor of SQL Server will benefit best with a minimum of three drives/devices, one for database, one for log and one for tempdb. Since you have space for it, use 8 SSD drives, each configured as RAID 1. Two each for system, database, log and tempdb. TempDB can actually be two drives configured as RAID 0 to give you more space. There is no real reason to have your  tempdb be redundant.
kevinhsiehNetwork Engineer

Commented:
Eight SSD for 10 people running a light SQL program, where they are concerned about license costs for a VM, is IMHO not appropriate. I don't have that many SSD disks for a system running hundreds of interactive users processing millions of transactions per month. We started with 2 SSD, and only added more for capacity reasons.

A pair of SSD if fine. Any more than two should only be for capacity reasons, which is unlikely to be needed.
Tore JacobsenSystem adminstrator

Author

Commented:
Hi and thanx for all answers.
So to conclude (don't have SSD drives avaiable now so 8 sata it is)
Instead og making 1 Raid 10 with all 8 drives. Installing Hyper-V and creating 5 vhd (dc and 4 for SQL)
You suggests making 4 mirrors? 1 for hyper-v and DC-vhd, and 3 for SQL? (only have 8 drives)
Top Expert 2014

Commented:
I'd just make a single array but slice it into a small RAID 10 for Hyper-V OS and the rest as bigger RAID 10 or RAID 6 for the VMs and data. Depends which controller you are getting with the machine though.
Philip ElderTechnical Architect - HA/Compute/Storage

Commented:
The best way to get maximum throughput and IOPS is to set up all disks in a single array and then have two logical/virtual disks set up on that array.

A single disk is about 150MiB/Second or 250 to 450 IOPS depending on the storage stack configuration.

A set of RAID 1 pairs would perform very poorly.
kevinhsiehNetwork Engineer

Commented:
Since you only have 8 HDD, the optimal configuration by far for SQL performance is all 8 drives in RAID 10. Every other configuration will provide fewer random IOPS to SQL with the given drives.

I only buy HDD if I am looking for capacity, such as for backups and recordings, but since OP is stuck with SAS HDD, RAID 10 is the best option, as everything else will relatively cripple performance.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial