Re: configuration: data and log file

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

RAID stands for Redundant Array of Inexpensive Disks. It allows you to take
two or more disks and configure them in such a way as to have fault
tolerance in the event one or more dies and increase performance. You need
more disks to create a Raid array and a controller that supports it.
http://www.enterprisestorageforum.com/hardware/features/article.php/726491

--
Andrew J. Kelly SQL MVP

"JTL" <jt@xxxxxxxxxxxxxxxxxxx> wrote in message
news:%231vyhldpGHA.2292@xxxxxxxxxxxxxxxxxxxxxxx
thanks so much for the help- a few more questions for you:

is RAID a type of fault tolerant drive array? assuming it is, would it be
possible to implement this on my current setup, or would i need to
purchase a different server with this specific capability?

JTL


"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:ed8NJDWpGHA.2292@xxxxxxxxxxxxxxxxxxxxxxx
That's not much to go on. But I can tell you that your configuration is
near the bottom of the lie when it comes to performance and availability.
Since neither of these drives are in a fault tolerant drive array you can
be in serious trouble if either of them fails. Plus a single drive is not
very good if you need to do lots of reads or writes. But in any case you
want to always try to seperate your log files from the data files on your
user and tempdb databases. By this I mean you want to place the log files
on one drive and the data files on the other. I would place the log files
on Drive C: and the data on Drive E:.

--
Andrew J. Kelly SQL MVP

"JTL" <jt@xxxxxxxxxxxxxxxxxxx> wrote in message
news:Ogo5rRUpGHA.4996@xxxxxxxxxxxxxxxxxxxxxxx
i have a dell poweredge 1850 rack server with two Ultra320 SCSI Drives -
one 70GB, one 300GB. i'm running sql server 2005 with a 40GB database
(this is the size of the .mdf file). for this type of scenario, what is
the recommended configuration for the sql server data and log files? i
know this is a broad topic, but want to know if i'm at least on the right
track.

currently, i have both the data and log files of the tempdb, as well as
my 40GB db, residing on the 300GB drive (Drive E), while the other
system databases are in their default location on the 70GB drive (which
also contains all the system files- Drive C).

i'm not sure if this is the optimal configuration, or whether i should
separate the drive locations for just the log files.

if anyone can at least point me toward a good article on sql server
hardware configurations that would be great.

tia,

jt







.

Relevant Pages

  • Re: A8N SLI Deluxe Question
    ... > Currently the drives are partitioned and my apps are on one partition. ... Someone suggested using RAID 0. ... The media rates for disks are still in the ~70MB/sec range ... the array reports certain errors. ...
    (alt.comp.periphs.mainboard.asus)
  • Re: [opensuse] Re: [OT] vmware and fake scsi devs
    ... Single threaded access to a raid array may not be helped by adding ... by adding disks to an array. ... So if you have M drives, ... stripe, then the existing parity data can be ignored. ...
    (SuSE)
  • Re: drive failure during rebuild causes page fault
    ... >the array. ... and upto half the drives in the array can fail without anything but ... Just make sure the controller can do "real" 1+0. ... and then use these 4 virtual disks in a RAID-0 stripe setup. ...
    (freebsd-stable)
  • Re: I deleted a raid 1 array, now cannot access the data on either disk.
    ... data on my two sata drives. ... >reserved sector on each disk, that tells the BIOS you have ... I have read of people doing a "delete array" ... >1) Buy two disks identical to the old two disks. ...
    (alt.comp.periphs.mainboard.asus)
  • Re: Is EMCs CAS Centera considered "permanent data"?
    ... >compatibility in replacement disks, as long as they are at least as ... - have firmware versions the array controllers recognize (most ... high-end arrays will only accept drives of known model and firmware ... RAID controllers, if one disk in the RAID group has higher capacity, ...
    (comp.arch.storage)