Re: SQL Server file setup across different volumes

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

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 12/01/04 

Date: Wed, 1 Dec 2004 08:54:57 -0500

Andrew,

It's not clear what those drive letters really represent. For instance are
C: & D: really two separate drive array's or just two logical drives on one
physical array? And what Raid level are the arrays or are they even arrays
at all? Ideally you want the log and data files to be separated from each
other and the log file should be on it's own Raid 1 array. Tempdb usually
can be on the same drive array as the data as long as it is not very heavily
used and it is a decent array to begin with. 

-- 
Andrew J. Kelly  SQL MVP
"Andrew Duncan" <andrew@duncanhcmc.com> wrote in message 
news:1e44a8ca.0412010035.5c39f086@posting.google.com...
> Hi,
>
> I've been looking to sort our SQL Server configuration out, which grew
> from a very small setup on a single disk to what is now a reasonably
> high volume database.
>
> Two things I am bearing in mind is that a: tempdb should be on
> separate physical disk from application database and b: log and data
> files should be on separate physical disks.
>
> My thoughts were as follows and I'd appreciate any comments as to
> whether this is the right choice: -
>
> C: OS
> D: MSSQL Programs + system databases
> E: Application db data file(s)
> F: Application db log file(s)
>
> I think this covers my two points above correctly. One thing I wasn't
> sure about was whether the log file for the system databases (esp.
> tempdb) should also go on F: or not.
>
> Any comments/opinions welcome
>
> Andrew Duncan

Relevant Pages

  • Re: mdadm and new FC6 install
    ... I built a RAID5 array way-back-when using mdadm to house data. ... The OS is installed on a separate drive. ... If I blow away the OS drive to do the FC6 install, ... point of separating the data and OS drives. ...
    (Fedora)
  • [Summary] saving disksuite info while rebuilding server
    ... "Caution - If a full install of Solaris is performed, ... make sure you have tape backups of everything. ... I had an old workgroup storage array with six 18G drives formatted RAID5 ...
    (SunManagers)
  • Re: best practice for hard drive upgrade
    ... pulled 2nd 250, rebuilt array, and ended up with a 250gb array. ... Apparently this RAID card - promise tx4310 - will not resize the array. ... If the original array consisted of 36GB drives a, ... Plug in one of your 500's and rebuild the array between the 250 and it. ...
    (microsoft.public.windows.server.sbs)
  • Re: Problems with software RAID on SATA
    ... Connected to this are two 320GB drives ... >>which I want to turn into a RAID1 array. ... >>I'm almost certain it's a problem with initting the RAID arrays at boot. ...
    (Debian-User)
  • Re: Hyper V, SBS 2008, Server 2008, XP - How best to organize my VMs on Disks and Partitions
    ... In the 'two arrays of different type' vs 'single array' scenario I expect ... writes less efficiently than a RAID single type. ... controller exceeds the read/write rate of the drives so any effect should be ... It is my belief that in a normal SBS environment and with decent cache on ...
    (microsoft.public.windows.server.sbs)