Database and transaction log question

New to SQL. I have 2 drives mirrored for os and sql installation files and a
raid 5 array for the database files for sql.
Should I create two partitions on the raid 5 array and put the database file
s on one and the transaction logs on another or is it not going to make a di
fference in performance since both partitions would still be on the same rai
d 5 array. Appreciate a qui
ck response to this question.
Also if it is recommended to place the transaction logs on a separate partit
ion on the same raid 5 array. Where do I set that in sql. Thanks a lot every
one.
OwenHaving multiple partitions on the same RAID5 array isn't going to buy you
anything. Put the logs on their own RAID1 volume. If you have the disks,
place the data files on a RAID10 volume. If you don't have the disks, then
put the data files on a RAID5. Never put the logs on the same array as the
data files.
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"owen" <anonymous@.discussions.microsoft.com> wrote in message
news:5C7163A9-C709-4466-A823-3DCA707A5912@.microsoft.com...
New to SQL. I have 2 drives mirrored for os and sql installation files and a
raid 5 array for the database files for sql.
Should I create two partitions on the raid 5 array and put the database
files on one and the transaction logs on another or is it not going to make
a difference in performance since both partitions would still be on the same
raid 5 array. Appreciate a quick response to this question.
Also if it is recommended to place the transaction logs on a separate
partition on the same raid 5 array. Where do I set that in sql. Thanks a lot
everyone.
Owen|||"owen" <anonymous@.discussions.microsoft.com> wrote in message
news:5C7163A9-C709-4466-A823-3DCA707A5912@.microsoft.com...
> New to SQL. I have 2 drives mirrored for os and sql installation files and
a raid 5 array for the database files for sql.
> Should I create two partitions on the raid 5 array and put the database
files on one and the transaction logs on another or is it not going to make
a difference in performance since both partitions would still be on the same
raid 5 array. Appreciate a quick response to this question.
> Also if it is recommended to place the transaction logs on a separate
partition on the same raid 5 array. Where do I set that in sql. Thanks a lot
everyone.
> Owen
Creating 2 partitions on a RAID 5 is going to give you no performance
advantage at all. In fact, though log files will benefit from the fault
tolerance afforded by RAID 5, as they are only written to, rather than read
from, they will not benefit from read performance advantages that RAID 5
gives you.
If your main concern is fault tolerance then stick the logs on the mirror.
That way if your entire RAID 5 controller goes up the Swanny, you still have
your log files.
If you are going to reposition your fils, simply go into Enterprise Manager,
properties of the database and change it there
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.614 / Virus Database: 393 - Release Date: 05/03/2004