Re: RAID-Best Practices ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 02/06/05


Date: Sun, 6 Feb 2005 14:56:30 -0500

My standard build recommendation on a 2850 is Mirrored drives (RAID 1) on
one channel for OS and TLOGs. Definitely 15KRPM, most likely 73GB. The
other four drive slots can be used for RAID 1+ 0 data on the second channel.
Depending on your actual data space requirements, you can use either 73GB
15KRPM drives or 146GB 10KRPM drives. Remember to order the split backplane
module to take advantage of the extra controller channel.

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Ron P" <RonP@discussions.microsoft.com> wrote in message
news:F8A7A612-C982-4912-B04A-BB0B63E5160E@microsoft.com...
> Thank you all for the input.
>
>  To clarify, If I have 20-25 users hitting this dedicated SQL server (DELL
> 2850 2.0 GB RAM, Dual Processors) which has the OS on a Raid 1 setup,
would I
> be better off with RAID 1+0 or Raid 1 for the data partition. Should I put
> the TLogs on the OS or on the data partition?
>
> TX again
> Ron P
>
> "Ron P" wrote:
>
> > I am moving from an Oracle Db server to a SQL server running on a new
w2k3
> > member server. Prior to purchase I would like to select the appropriate
RAID
> > level for the server which gives me the best performance and recovery
options.
> >
> > I heard something about RAID 10?
> > Appreciate it!
> >
> > RPM


Relevant Pages

  • Re: Advice Needed on Large Scale DataBases
    ... If you put that large table on its own RAID 10 array if it gets writtent ... lot of drives in the array for best performance and put that array on ... need the improved memory allowance of SQL Server 2000 EE. ...
    (microsoft.public.sqlserver.server)
  • Re: question about drives configuration
    ... If the amount of cache is sufficient to buffer all the I/O to the drives ... low end SAN controllers you usually only get up to 512K of controller cache. ... you should not be thinking RAID 5. ... > Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.clustering)
  • Re: disk partitioning best practice
    ... On one channel I have 2x36GB SCSI HDD ... have 7x73GB SCSI HDD RAID 5 with one hot spare. ... No if my OS drives go out ... partitions for page file or user settings ...
    (microsoft.public.windows.server.general)
  • Re: Data spread over disk volumes
    ... First off your probably best to configure the drives in ... a RAID 5 or RAID 0+1 and let the hardware take care of the spanning of the ... SQL Server uses a fill algorithm that is dictated by the ... amount of free space in the file. ...
    (microsoft.public.sqlserver.setup)
  • Re: IDE RAID opinions please
    ... The subject is Raid Drive implementation. ... If you think that sharing a channel ... SCSI RAID was on old technology. ... drives are on the way. ...
    (comp.unix.bsd.freebsd.misc)