SQL Server Transaction Log RAID

Posted by Eric Maibach on Server Fault See other posts from Server Fault or by Eric Maibach
Published on 2008-11-16T21:16:46Z Indexed on 2010/04/12 21:33 UTC
Read the original article Hit count: 311

Filed under:
|

We have three SQL Server servers, and each server has a about five or six databases on it. We are in the process of moving these servers to a new SAN and I am working on the best RAID configuration. Currently all of the log files for all of the databases share a RAID array, there is nothing else on this RAID array except for the log files, but all of the databases use this same array for their log files.

I have read that it is best to have log files on separate disks. But in our case I am not sure whether it would be best to have one big array with about 8 drives that all the log files are on. Or would it be better to create four two disk arrays and give some of the larger databases their own dedicated disks for their log files?

© Server Fault or respective owner

Related posts about sql-server

Related posts about raid