• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 456
  • Last Modified:

HostRaid vs ZCR for RAID 10

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
moruda
Asked:
moruda
  • 4
  • 2
1 Solution
 
_Commented:
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
 
morudaAuthor Commented:
SAS 15k RPM
0
 
_Commented:
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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
morudaAuthor Commented:
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
 
_Commented:
>> 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
 
_Commented:
Thank you much.    : )
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

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