During my career of the support engineer for one MS SQL powered application, I learned that I can achieve better performances of the system only if I move all DB files to the separate drive. Additionally, I’m always trying to separate data and log files.
By default, MS SQL server will try to install everything on the C: drive. You should never install anything except programs on that drive. Every other file, especially those which will be continuously read or written, should be placed on other drives. Continue reading
MiViLiSNet 