Re: New Server RAID setup

From: RAJ (RAJ_at_discussions.microsoft.com)
Date: 07/09/04


Date: Fri, 9 Jul 2004 11:11:01 -0700

The server is going to be used as a .NET server, for document managment. The utilization, I believe is going to be low. There are going to be at most 150 users utilizing the server. As far as RAID 1+0, am I correct in saying the OS & SQL application be placed on a RAID 0 array & the log files be placed on a RAID 1?

-- 
RAJ
"Andrew J. Kelly" wrote:
> How you should configure the drives depends a lot on what your going to do
> with them.  If you app is relatively small or only has a few transactions
> per second that approach sounds fine.  The more trans / sec you get the more
> likely you will see disk issues unless you place the log file on it's own
> Raid 1.  I would say start witht he Raid 1+0 and see how it goes.
> 
> -- 
> Andrew J. Kelly  SQL MVP
> 
> 
> "RAJ" <RAJ@discussions.microsoft.com> wrote in message
> news:281E5061-F153-4635-82D4-2EB720D27A4B@microsoft.com...
> > Hello,
> > I have a new IBM eServer w/ 5 identical HD's.  I'm new to SQL and I'm
> researching the best HD configuration.  I've come to the conclusion that
> using 4 of the HD's for a RAID 10 configuration and keeping the 5th drive as
> a hotswap backup drive.  With that said I have two questions.
> > 1.  Can I go wrong creating a RAID 10 & a hotswap drive?
> > 2.  I there anything else I should consider regarding the config. of the
> HD's?
> > Any and all suggestions welcome!
> > Thank You!
> >
> > -- 
> > RAJ
> 
> 
> 


Relevant Pages

  • Re: New Server RAID setup
    ... How you should configure the drives depends a lot on what your going to do ... I would say start witht he Raid 1+0 and see how it goes. ... "RAJ" wrote in message ... using 4 of the HD's for a RAID 10 configuration and keeping the 5th drive as ...
    (microsoft.public.sqlserver.setup)
  • Re: Extremely high % Disk Time .. How is this possible??
    ... As Andrew pointed out, it is the physical drives that appear to be limited. ... Slicing them into logical drives may look better but it does not increase IO ... and read bytes/write bytes per second as true measures of disk performance. ... Roughly 30-40 % of ransactions occur in tempDB ...
    (microsoft.public.sqlserver.clustering)
  • Re: Extremely high % Disk Time .. How is this possible??
    ... Andrew J. Kelly SQL MVP ... > Slicing them into logical drives may look better but it does not increase ... I prefer to look at disk queue ... >>> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: clearing Vinum configurations
    ... the configuration currently read into memory, and NOT clear the Vinum ... On another box, again 4.8-RELEASE only with IDE instead of SCSI drives, ... plexes on an uninitialized drive and as such, ...
    (freebsd-questions)
  • Re: new dell, dumb operator needs help!
    ... hard disks that are not in a raid configuration. ... listed under 'hard disk'. ... drives in 'my computer' then it is pretty clear that you do not have raid ...
    (alt.sys.pc-clone.dell)