Saturday, February 25, 2012

Can anyone recommend a super fast Raid 10 Scsi controller for SQL?

I have really had enough of Dell's PERC/3 DC controllers.
Firstly they implement Raid 10 as a span of mirrors rather than a stripe.
Secondly they are just very slow even on a plain stripe.
We paid top dollar for these a couple of years ago but they are really
holding our SQL Server back. We have 24 15k U320 disks and three controllers
and wanted the best, safest solution.
ie Raid 10.
Any controller recommendations?
Thanks
PaulWe used such controlled, moved to EMC/Dell CX300.
"Paul Cahill" wrote:
> I have really had enough of Dell's PERC/3 DC controllers.
> Firstly they implement Raid 10 as a span of mirrors rather than a stripe.
> Secondly they are just very slow even on a plain stripe.
> We paid top dollar for these a couple of years ago but they are really
> holding our SQL Server back. We have 24 15k U320 disks and three controllers
> and wanted the best, safest solution.
> ie Raid 10.
> Any controller recommendations?
> Thanks
> Paul
>
>|||I'd love to go down this route but it's not a financial option to ditch the
24 scsi drives (and the powervaults).
At this point replacing the Perc3/DCs is the only possibility.
Paul
"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:02EE84E1-7BCF-4801-894C-F02EE7A76B19@.microsoft.com...
> We used such controlled, moved to EMC/Dell CX300.
> "Paul Cahill" wrote:
>> I have really had enough of Dell's PERC/3 DC controllers.
>> Firstly they implement Raid 10 as a span of mirrors rather than a stripe.
>> Secondly they are just very slow even on a plain stripe.
>> We paid top dollar for these a couple of years ago but they are really
>> holding our SQL Server back. We have 24 15k U320 disks and three
>> controllers
>> and wanted the best, safest solution.
>> ie Raid 10.
>> Any controller recommendations?
>> Thanks
>> Paul
>>|||Dell has the Perc4's out. They are all based on the Adaptec controller.
With 24 drives, unless you use Fiber, you won't get much faster performance.
SCSI is rather slow over copper.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Paul Cahill" <noname@.anon.com> wrote in message
news:OlE46KzcFHA.584@.TK2MSFTNGP15.phx.gbl...
> I'd love to go down this route but it's not a financial option to ditch
> the 24 scsi drives (and the powervaults).
> At this point replacing the Perc3/DCs is the only possibility.
> Paul
> "andsm" <andsm@.discussions.microsoft.com> wrote in message
> news:02EE84E1-7BCF-4801-894C-F02EE7A76B19@.microsoft.com...
>> We used such controlled, moved to EMC/Dell CX300.
>> "Paul Cahill" wrote:
>> I have really had enough of Dell's PERC/3 DC controllers.
>> Firstly they implement Raid 10 as a span of mirrors rather than a
>> stripe.
>> Secondly they are just very slow even on a plain stripe.
>> We paid top dollar for these a couple of years ago but they are really
>> holding our SQL Server back. We have 24 15k U320 disks and three
>> controllers
>> and wanted the best, safest solution.
>> ie Raid 10.
>> Any controller recommendations?
>> Thanks
>> Paul
>>
>|||When we bought the Perc3/dcs we thought 3 dual channel controllers would be
OK. We didn't realise they cannot do true raid 10.
Many of our disks are not being hit as the raid 10 arrays are span of
mirrors not a stripe. I built most of the arrays as a set of four and one
set of six.
eg the log file is on a raid 10 set of 4 18Gb 15k drives but only two lights
flash because the log is smaller than 18gb. If it was a stripe of mirrors
all four lights would flash.
Any idea if the perc4 does true raid 10.
Paul
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23HgnHJ1cFHA.612@.TK2MSFTNGP12.phx.gbl...
> Dell has the Perc4's out. They are all based on the Adaptec controller.
> With 24 drives, unless you use Fiber, you won't get much faster
> performance. SCSI is rather slow over copper.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Paul Cahill" <noname@.anon.com> wrote in message
> news:OlE46KzcFHA.584@.TK2MSFTNGP15.phx.gbl...
>> I'd love to go down this route but it's not a financial option to ditch
>> the 24 scsi drives (and the powervaults).
>> At this point replacing the Perc3/DCs is the only possibility.
>> Paul
>> "andsm" <andsm@.discussions.microsoft.com> wrote in message
>> news:02EE84E1-7BCF-4801-894C-F02EE7A76B19@.microsoft.com...
>> We used such controlled, moved to EMC/Dell CX300.
>> "Paul Cahill" wrote:
>> I have really had enough of Dell's PERC/3 DC controllers.
>> Firstly they implement Raid 10 as a span of mirrors rather than a
>> stripe.
>> Secondly they are just very slow even on a plain stripe.
>> We paid top dollar for these a couple of years ago but they are really
>> holding our SQL Server back. We have 24 15k U320 disks and three
>> controllers
>> and wanted the best, safest solution.
>> ie Raid 10.
>> Any controller recommendations?
>> Thanks
>> Paul
>>
>>
>

No comments:

Post a Comment