Monday, March 26, 2012

Raid 10 and SQL

Are there any significant performance issues between running raid 5 verses
raid 10
with equal hardware configurations?. Thanks for being there to help, you
people have been life-savers.
Hi
Check out SQL Server 2000 Performance Tuning Technical Reference ISBN
0-7356-1270-6
There is a performance gain from Raid 10, this has to be taken into the
context of the system as a whole and what loads it will be under.
John
"coenzyme" wrote:

> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>
|||Yes for sure..
Only think i can say that cost is high with RAID 10 but for performance it's
great..
"coenzyme" wrote:

> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>
|||in most cases, yes.
I think I have read articles that suggest anything over 10% Writes you
should get off of RAID 5
Greg Jackson
PDX, Oregon
|||We found that RAID10 was over twice as fast when used for our database dump
volume as compared to RAID5. Not to mention that RAID10 is significantly
more tolerant of disk failures.
Mike Kruchten
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:74B28604-FE4A-4553-B134-269A3E6FBD1F@.microsoft.com...
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>
|||Check out what this site has to say about Raid 5:
http://www.baarf.com/
Andrew J. Kelly SQL MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:74B28604-FE4A-4553-B134-269A3E6FBD1F@.microsoft.com...
> Are there any significant performance issues between running raid 5 verses
> raid 10
> with equal hardware configurations?. Thanks for being there to help, you
> people have been life-savers.
>

No comments:

Post a Comment