Solved

HostRaid vs ZCR for RAID 10

Posted on 2006-10-25
6
411 Views
Last Modified: 2010-04-03
Hi,
We are configuring a database server for RAID 10 and are wondering if there are any comparisons or benchmarks of the pros/cons of using the HostRaid built into the motherboards--Dell, Supermicro, etc... or using the ZCR card for Supermicro or a dedicated Adaptec or other card for the RAID. Are the benefits large enough to outweigh the costs of the extra equipment? or is HostRaid fine for RAID 10?

Thanks
0
Comment
Question by:moruda
  • 4
  • 2
6 Comments
 
LVL 32

Expert Comment

by:_
ID: 17809400
What kind of drives?

I would invest in a real hardware RAID card if this database is work related.
Better performance.
3ware also still seems to make a true hardware RAID card.

Nice little rant on Host Raid cards.
http://www.brentnorris.net/blog/?p=158
0
 

Author Comment

by:moruda
ID: 17809410
SAS 15k RPM
0
 
LVL 32

Expert Comment

by:_
ID: 17809517
Sweet.

If you do a Host Raid, the cpu will have to have to take time away from chewing on the database, to manage the disk drives.

Whether a hardware raid is worth it, depends on what kind of system specs you have, and how heavy the workload is going to be.

0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 

Author Comment

by:moruda
ID: 17809536
considering that we are looking at (2) 5100 series processors - 4 cores-- and the current config is running fine on a dual 2.4 xeon with raid 1, I would think that we have a lot of extra power available for use -- unless 64bit windows /sql 2005 is a LOT more cpu intensive than 2003/sql 2000
0
 
LVL 32

Accepted Solution

by:
_ earned 500 total points
ID: 17817028
>> unless 64bit windows /sql 2005 is a LOT more cpu intensive...

Not that I have heard of. Just be sure you can get all the drivers you need, first.

Sounds like  you will have no problem with cpu load, so either raid should work.

This is a nice place to start, to help decide which is better for you:
http://www.raidrecoveryguide.com/hardware-software.html

Adaptec's white papers:
http://www.adaptec.com/en-US/_whitepapers/tech/

Hardware RAID vs. Software RAID <.PDF file from the Adaptec link>
http://www.adaptec.com/NR/rdonlyres/14B2FD84-F7A0-4AC5-A07A-214123EA3DD6/0/4423_SW_HWRAID_10.pdf

This is mostly Linux links, but there should be some good background info in there:
http://www.google.com/search?hl=en&q=software+raid+vs+hardware+raid&btnG=Google+Search

You might find this interesting:
http://www.storagesearch.com/tandberg-raidn-art.html
0
 
LVL 32

Expert Comment

by:_
ID: 17895686
Thank you much.    : )
0

Featured Post

Network it in WD Red

There's an industry-leading WD Red drive for every compatible NAS system to help fulfill your data storage needs. With drives up to 8TB, WD Red offers a wide array of solutions for customers looking to build the biggest, best-performing NAS storage solution.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now