Solved

HostRaid vs ZCR for RAID 10

Posted on 2006-10-25
6
418 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
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…

813 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