Re: configuration: data and log file

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

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: 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: Advice Requested : Disaster Recovery with 2 Drives (No Raid) with SQL Server 2008
    ... As far as splitting the transaction log files and the data files, that's always a good strategy, but for a 1.3GB database... ... I am running SQL Server 2008 Enterprise, ... backups every 4 hours to one of the two Drives. ...
    (microsoft.public.sqlserver.programming)
  • Re: Problems with SQL Server 2005 Install on Cluster
    ... However, on the previous install, the installation created the SQL Server instance and IP address for SQL Server. ... I don't think it automatically assigned both drives as a dependency for SQL Server. ... If I run the configuration after the installation, there is an option there to designate where the log files go. ...
    (microsoft.public.sqlserver.setup)
  • Re: Problems with SQL Server 2005 Install on Cluster
    ... the installation created the SQL Server instance and IP ... I don't think it automatically assigned both drives ... there is an option there to designate where the log files go. ...
    (microsoft.public.sqlserver.setup)
  • configuration: data and log file
    ... recommended configuration for the sql server data and log files? ... currently, i have both the data and log files of the tempdb, as well as my ... i'm not sure if this is the optimal configuration, ... if anyone can at least point me toward a good article on sql server hardware ...
    (microsoft.public.sqlserver.setup)