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
sql-server
|raid
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