Re: SQL installation recommendations

Another thing to consider is having the different RAID arrays on separate
channels. If all 3 are going through the same data channel, that can negate
a lot of the advantages being gained by having separate arrays/drives.....
This will usually require two RAID adapters. One with two internal channels
and the other with one or two.... It may also require hardware kits to
separate the drives into different arrays.

--
Regards,
Hank Arnold

"Jasper Smith" <jasper_smith9@xxxxxxxxxxx> wrote in message
news:e7bRsq$3FHA.2364@xxxxxxxxxxxxxxxxxxxxxxx
> 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 7.0 and SMS 2003
    ... Install the OS on one drive and SMS & SQL on the other drive. ... If possible, use separate HD channels. ...
    (microsoft.public.sms.setup)
  • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... We are physically separating log and data files on separate disks. ... the binn folder which contains the sql server executable among other things. ...
    (microsoft.public.sqlserver.setup)
  • Re: Server Configuration
    ... It's always a good idea to separate the log from the data files onto ... > of a concern in an environment like mine, where the transaction rate is ... and Data) on separate RAIDs--that would be 3 RAIDs in one box! ... >> RAID you might want to see if you can't do a RAID 1+0 instead of 5. ...
    (microsoft.public.sqlserver.setup)
  • Re: Dual Tuner support
    ... How are the two STBs connected to your computer via 2 separate coax ... connecore to 2 separate tuner cards or via 2 searate S-Video and audion to ... resulting in a final setup of 2 boxes whose channels will ... configure both boxes, i lose the ability to have media center change the ...
    (microsoft.public.windows.mediacenter)
  • Re: Proposal: make RAID6 code optional
    ... systems that are only interested in RAID4 or RAID5. ... RAID 4 is really just another layout scheme for RAID 5. ... RAID 6 to a separate module makes sense. ... the raid6 module depend on the raid5 module. ...
    (Linux-Kernel)