Re: question about drives configuration

RAID5 requires many more IO operations for a transactional change than any
of the other RAID configurations. This can impact cache performance since
it requires more cache space to handle the extra block read-writes. The
only place I find RAID5 to be good is where there is a daily load process
and everything else is read-only. transactional system, SAN or not, needs a
RAID 1+0 layoud for best performance.

Geoff N. Hiten
Microsoft SQL Server MVP


"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:%23R0VkFghFHA.4028@xxxxxxxxxxxxxxxxxxxxxxx
>I was under the impression that with write-back caching the performance
> difference between raid 5 and the raid 01, 10,1 variants is much the same.
> Is this not true?
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Geoff N. Hiten" <sqlcraftsman@xxxxxxxxx> wrote in message
> news:uqzYB7ygFHA.3608@xxxxxxxxxxxxxxxxxxxxxxx
>> The normal drive performance rules do not change on a cluster. RAID 1
>> (mirror) or 1+0 (stripe of mirror sets) gives the best performance, but
> has
>> the highest per-byte storage cost. RAID 5 (stripe with parity) is very
> low
>> cost but does have a performance hit for transactional data and SQL log
>> usage. RAID 0 + 1 (mirror of stripe sets) is not recommended. RAID 10
>> is
> a
>> generic term for sometimes Raid 1+0 and Sometimes RAID 0+1. Make sure
> which
>> one you are getting.
>>
>> Geoff N. Hiten
>> Microsoft SQL Server MVP
>>
>> "Chen" <Chen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:F2963003-41D2-4132-B74C-FBF92EE46984@xxxxxxxxxxxxxxxx
>> > Hi,
>> >
>> > We will build new clustering SQL Server. The question is that what kind
>> > drives configuration for user-defined database data files and
> transaction
>> > log
>> > files will improve performance, RAID 1+0, RAID 0+1, RAID 5 or RAID 10
> etc.
>> >
>> > Regards!
>> > -Chen
>> >
>>
>>
>
>


.

Relevant Pages

  • Re: Transaction Isolation Level
    ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
    (comp.databases.ms-sqlserver)
  • RE: IIS & SQL
    ... it is best to place SQL Server on a separated ... database on a RAID 5 disk. ... RAID 5 provides redundancy of all data on the ... 298475 HOW TO: Troubleshoot Application Performance Issues ...
    (microsoft.public.sqlserver.setup)
  • Re: Windows Completely Locks Up!! FREEZE
    ... failing to start/run the Distributed Transaction Coordinator. ... Error Specifics: ... The Business Contact Manager SQL Server Startup Service service terminated ... The service did not respond to the start or control request in a timely ...
    (microsoft.public.windowsxp.general)
  • Re: Asynchronous Stored Procedure Never Returns - Help?
    ... If you have the Sql Server 2000 or 2005 docs they are thorough and can be ... for Transaction SQL Reference from the drop-down or select a keyword from ... your query in Query Analyzer or Sql Server Management Studio, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Transaction Abort in a trigger SQL 2008, writing to event log
    ... transaction could still be doomed at some point, ... With the current functionality in SQL Server ... you should roll back the transaction in your error handler. ... global cursor in a stored procedure. ...
    (microsoft.public.sqlserver.programming)