Does it matter where I put my Transaction Log if I am in Simple Recovery Mode? I put the Data and Transaction file on the same disk (RAID 5) and TempDB in RAID 10. Will I get any performance increase if I move the Trans Log to a separate drive?
The question is a little confusing and indicates a common misconception about logfiles. The usage of a transactionlog is not different if you compare it against SIMPLE or FULL recovery mode. The only difference is that in SIMPLE mode, the space being used in the logfile is marked as "can be overwritten". Generally, you should put your data- and logfiles on seperate disk (in order to prevent IO issues). I recommend this free PDF from red gate: