• I think whether you break up the logs onto separate drives (and in extreme cases separate HBA's) is situational, regardless of the current best practices. If you've got a 1TB db and log files, sure, why not break it up. But if you have 50 or 500 db's, you're not going to see the same amount of improvement by moving the log files - after all, the 'theory' is that log writes are mainly sequential. If SQL is writing to 500 log files, don't see that as very sequential.

    As far as RAID5, let me go against the grain and vote for that too! Yes, there are times when RAID10 is more appropriate, but cost is almost always an issue. But as Darren mentioned, if you were on RAID10 and the SAN vendor sets up RAID5, you'll probably see the difference.

    Hank, if you're still having issues with the cluster, post in the discussion area and maybe we can help you figure it out.

    Thanks everyone for reading and commenting. I probably will do a follow up article in a few weeks. So far so good!

    Andy

    http://www.sqlservercentral.com/columnists/awarren/