For best performance, the transaction log should be on a separate disk.
Does the writing of the log benefit from a battery backed controller as well? If not, what do people think about writing the transaction log to a flash card or the like?
Does the writing of the log benefit from a battery backed controller as well? If not, what do people think about writing the transaction log to a flash card or the like?
