Transaction Log and Raid

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard Douglass - 15 Mar 2008 20:47 GMT

I am looking to improve performance of the sql system. I have the trans log
split onto its own RAID5 drive. We are thinking about going to RAID0 to try
abd boost throughput. Any ideas?

Richard

Reply to this Message

Andrew J. Kelly - 15 Mar 2008 21:12 GMT

Use Raid 10 instead. Raid 5 is bad for heavy write activity such as log
files but a Raid 1 or 4 disk Raid 10 will give you redundancy and
efficiency. Just make sure that you only place Log files on the array. And
don't partition the array and try to put other things on the other partition
as that will defeat the purpose as well.

Signature

Andrew J. Kelly SQL MVP
Solid Quality Mentors

>I am looking to improve performance of the sql system. I have the trans
>log split onto its own RAID5 drive. We are thinking about going to RAID0
>to try abd boost throughput. Any ideas?
>
> Richard

Reply to this Message

Linchi Shea - 16 Mar 2008 03:28 GMT

I agree with Andrew's comments in general. For your particular case, you need
to first identify where your performance bottleneck and allocate resources to
resolve that bottleneck. If the bottleneck is not on the log I/Os, getting a
faster RAID won't give you better performance.

Linchi

> I am looking to improve performance of the sql system. I have the trans log
> split onto its own RAID5 drive. We are thinking about going to RAID0 to try
> abd boost throughput. Any ideas?
>
> Richard

Reply to this Message

Greg D. Moore (Strider) - 16 Mar 2008 06:33 GMT

>I am looking to improve performance of the sql system. I have the trans
>log split onto its own RAID5 drive. We are thinking about going to RAID0
>to try abd boost throughput. Any ideas?
>
> Richard

Reply to this Message

Greg D. Moore (Strider) - 16 Mar 2008 06:34 GMT

>I am looking to improve performance of the sql system. I have the trans
>log split onto its own RAID5 drive. We are thinking about going to RAID0
>to try abd boost throughput. Any ideas?
>
> Richard

As others have mentioned, do NOT do RAID 0.

This will increase your chance of data loss.

Either RAID 1 or RAID 10.

Signature

Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Reply to this Message