I am considering implementing Transactional Logging. In reading, it would seem that using a separate controller with two mirrored disks is the general recommendation. I may be able implement this configuration on some servers, but not all. Is this a hard and fast rule? Can the transaction logs be placed on other drives (one assumes not on the same drive with the page file?). Any real world experiences would be helpful, thanks!
Subject: Transactional Logging - Hardware
The recommendation is to place transaction logs on a different physical drive, ideally on a dedicated controller. But it really all depends on how busy your server is.
You can have transaction logs even on the same disk, if there is enough free space and disk i/o in general is not stretched. Not ideal, but it can still work.