Re: question about drives configuration
- From: "Geoff N. Hiten" <sqlcraftsman@xxxxxxxxx>
- Date: Thu, 7 Jul 2005 16:00:58 -0400
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
>
.
- Follow-Ups:
- Re: question about drives configuration
- From: Hilary Cotter
- Re: question about drives configuration
- References:
- question about drives configuration
- From: Chen
- question about drives configuration
- Prev by Date: question about drives configuration
- Next by Date: RE: question about drives configuration
- Previous by thread: question about drives configuration
- Next by thread: Re: question about drives configuration
- Index(es):
Relevant Pages
|
