Our sql server is a VM with vmware. I know that the classical way to set up partitions for a sql server was to have 3 partitions.
1) for the os
2) for the mdf
3) for the ldf files
I have also heard that since vmware has came to prominence that this is not a big concern anymore. meaning.... you can responsibly run a sql server install on 2 partitions now.
2) mdf and ldf
Can someone confirm that it is ok to run sql servers with either setup. currently we are choosing the second way of setting up our sql servers, but i have a vendor that is highly recommending that we go to the classic 3 partition setup.
Thanks a bunch!