Thursday, February 16, 2012

Can performance improve using RAID 0 if have only one CPU?

Hi,
If I have only one CPU in my SQL Server computer, can the performance have
any improvement by using RAID0?
Thanks
FrankWhy would you want to do that ? You would get peformance , no doubt, but no
fault tolerance.. You could go with RAID 1 or 1+ 0 to get performance and
the fault tolerance ..
"Frank" <wangping@.lucent.com> wrote in message
news:%23TxSv8NDFHA.1932@.TK2MSFTNGP14.phx.gbl...
> Hi,
> If I have only one CPU in my SQL Server computer, can the performance have
> any improvement by using RAID0?
> Thanks
> Frank
>|||Thanks Hassan,
I just read about the RAID, so I am wondering about this.
I think the RAID 0 will strip the data for read and write, if have more than
one processor, then the read and write can be done by different processors
on different strips. If only one processor, then I suspect there will be any
performance improvement for the processor to go to different strips.
Apprecite your further information
Frank
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OdsweGODFHA.2620@.tk2msftngp13.phx.gbl...
> Why would you want to do that ? You would get peformance , no doubt, but
no
> fault tolerance.. You could go with RAID 1 or 1+ 0 to get performance and
> the fault tolerance ..
> "Frank" <wangping@.lucent.com> wrote in message
> news:%23TxSv8NDFHA.1932@.TK2MSFTNGP14.phx.gbl...
> > Hi,
> >
> > If I have only one CPU in my SQL Server computer, can the performance
have
> > any improvement by using RAID0?
> >
> > Thanks
> > Frank
> >
> >
>|||Well you definitely need to worry about Fault Tolerance as disks have a high
possibility of going bad. And with regards to performance, you will not see
a whole lot of difference with regards to CPUs and IO read/writes . Your
performance could be looked at right from the application level. Why not
consider RAID 1 or RAID 1+ 0
How many disks along with size do you have and how much space do you need ?
"Frank" <wangping@.lucent.com> wrote in message
news:ueQ2gKODFHA.2232@.TK2MSFTNGP14.phx.gbl...
> Thanks Hassan,
> I just read about the RAID, so I am wondering about this.
> I think the RAID 0 will strip the data for read and write, if have more
than
> one processor, then the read and write can be done by different processors
> on different strips. If only one processor, then I suspect there will be
any
> performance improvement for the processor to go to different strips.
> Apprecite your further information
> Frank
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:OdsweGODFHA.2620@.tk2msftngp13.phx.gbl...
> > Why would you want to do that ? You would get peformance , no doubt, but
> no
> > fault tolerance.. You could go with RAID 1 or 1+ 0 to get performance
and
> > the fault tolerance ..
> >
> > "Frank" <wangping@.lucent.com> wrote in message
> > news:%23TxSv8NDFHA.1932@.TK2MSFTNGP14.phx.gbl...
> > > Hi,
> > >
> > > If I have only one CPU in my SQL Server computer, can the performance
> have
> > > any improvement by using RAID0?
> > >
> > > Thanks
> > > Frank
> > >
> > >
> >
> >
>|||Frank,
you would likely see improvement by striping even with a single processor...
One processor can handle many concurrent IOs... As the others have said,
raid 0 gives you no fault tolerance... If a single disk in the stripe set
goes bad, everything will go down... Whether or not that is a requirement of
your configuration is a business decision...
Another way to increase IO throughput is to create several files within the
filegroup... This will allow sql to do parallel IO for a single query..
hope this helps.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23hp8RRODFHA.960@.TK2MSFTNGP09.phx.gbl...
> Well you definitely need to worry about Fault Tolerance as disks have a
> high
> possibility of going bad. And with regards to performance, you will not
> see
> a whole lot of difference with regards to CPUs and IO read/writes . Your
> performance could be looked at right from the application level. Why not
> consider RAID 1 or RAID 1+ 0
> How many disks along with size do you have and how much space do you need
> ?
> "Frank" <wangping@.lucent.com> wrote in message
> news:ueQ2gKODFHA.2232@.TK2MSFTNGP14.phx.gbl...
>> Thanks Hassan,
>> I just read about the RAID, so I am wondering about this.
>> I think the RAID 0 will strip the data for read and write, if have more
> than
>> one processor, then the read and write can be done by different
>> processors
>> on different strips. If only one processor, then I suspect there will be
> any
>> performance improvement for the processor to go to different strips.
>> Apprecite your further information
>> Frank
>> "Hassan" <fatima_ja@.hotmail.com> wrote in message
>> news:OdsweGODFHA.2620@.tk2msftngp13.phx.gbl...
>> > Why would you want to do that ? You would get peformance , no doubt,
>> > but
>> no
>> > fault tolerance.. You could go with RAID 1 or 1+ 0 to get performance
> and
>> > the fault tolerance ..
>> >
>> > "Frank" <wangping@.lucent.com> wrote in message
>> > news:%23TxSv8NDFHA.1932@.TK2MSFTNGP14.phx.gbl...
>> > > Hi,
>> > >
>> > > If I have only one CPU in my SQL Server computer, can the performance
>> have
>> > > any improvement by using RAID0?
>> > >
>> > > Thanks
>> > > Frank
>> > >
>> > >
>> >
>> >
>>
>

No comments:

Post a Comment