Re: configuration: data and log file

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: configuration: data and log file
    ... But I can tell you that your configuration is near ... neither of these drives are in a fault tolerant drive array you can be in ... By this I mean you want to place the log files on one ... the recommended configuration for the sql server data and log files? ...
    (microsoft.public.sqlserver.setup)
  • Re: tempdb on C drive?
    ... performance from having the tempdb data files, User db data files and Log ... files all on different physical drives or drive arrays. ... While adding more log files to the log drive array decreases the ...
    (microsoft.public.sqlserver.setup)
  • Re: Backup Error 0x800423F0
    ... So much for recommending that the database and log files be on separate ... drives. ... Now a machine that succesfully completed a ASR set backup prior ...
    (microsoft.public.windows.server.general)
  • Re: Install SS 2005 - log files best practice
    ... Put transaction log files on a separate drive from data files. ... people don't realize it is not two separate physical drives. ... I am a programmer, not a DBA, and have to install Sql Server 2005. ... The network guy thinks it's okay to just install everything on the C ...
    (microsoft.public.sqlserver.setup)
  • Re: configuration: data and log file
    ... RAID stands for Redundant Array of Inexpensive Disks. ... Since neither of these drives are in a fault tolerant drive array you can ... By this I mean you want to place the log files ...
    (microsoft.public.sqlserver.setup)