It's common practice to separate out the data from the log files on SQL server. Does this still hold true as best practice when working with SharePoint databases.
For example using the above example I could have my log drive have the following files:
And then on my data drive have the following:
Alternatively would it be more practical place each database (data and log) on it's own drive like so:
The other thing I want to better understand is how this advice is affected when the WSS_Content_MainSite database gets larger and we decide to add another database to the web application. Should this new database go on the same place as the other database files or in isolation?