Re: SQL installation recommendations

The idea is to isolate IO profiles. Data files tend to be random read/write
and log files are predominately sequential write. If your system for example
has C,D + E drives then Windows + pagefile on C, datafiles on D, log files
on E. It's irrelavent were you put the Program Files for SQL (assuming
you'll move tempdb to be on D + E in this example). It wouldn't be a good
idea to put the windows pagefile on the transaction log drive.

--
HTH

Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"Dan Carpenter" <eterra@xxxxxxxxxxxxxxxx> wrote in message
news:u2laaf$3FHA.128@xxxxxxxxxxxxxxxxxxxxxxx
> Hello,
>
> I was curious if it is recommended to install the SQL program files and
> Database files on separate partitions and what the reasons for doing so
> are. I am under the impression that this improves performance but I was
> looking for some explanation. Also, given how often the transaction logs
> are written to would it also be recommended to place them on yet another
> partition if one was available?
>
> The system I plan to install SQL 2005 on is using SCSI disks and it has 3
> RAID 1 partitions. I was planning on installing the program files on one,
> the database files on another, and the transaction files on the last one
> along with the page file. I was curious if this was a good idea. I can't
> seem to find any recommendations to do this in the offcial documentation
> so I was wondering if anyone could supply any links. Thank you.
>
> -Dan Carpenter
>


.

Relevant Pages

  • Re: SQL Server 2005 Express Ed (KB 921896): errorcode 0x65B
    ... Can you search these log files for the ... The automatic update of my MS SQL Server 2005 Express ... Package Language: 1043 ... Product Installation Status ...
    (microsoft.public.windowsupdate)
  • Re: Reading IIS Logs into SQL Server
    ... delimited log files, including IIS and many others, like event log, and ... optionally inject the results into SQL or display on the console. ... There are many users of Log Parser out there (I think there's a MS newsgroup ... Does anyone whos sells web reporting tools also ...
    (microsoft.public.inetserver.iis)
  • Re: 20GB Partion C: running out of space
    ... SQL data and log files usually use .mdf & .ldf. ... Are you properly backing up your SQL database? ... Are you using Exchange for email? ...
    (microsoft.public.windows.server.sbs)
  • Re: 20GB Partion C: running out of space
    ... Are these .log files in your Windows folder really large? ... just text files that log install information and aren't too big. ... exchange database to D: ...
    (microsoft.public.windows.server.sbs)
  • MS03-031 installation error :112
    ... I was trying to install the patch MS03-031 on our SQL ... log files would be to the tune of: ... It would fail at this step but would fail with different ...
    (microsoft.public.sqlserver.security)