For a small business where SQL instance is running 8 Databases supporting only 20 users and low number of transactions per second.
In a virtual environment do the traditional recommendations for SQL, i.e. separating log files from data files from Temp db on their own spindles still apply? If not and all can reside on the same OBR10 are there pros/cons performance wise for using separate VHDs for each?
We are new to RAID and Virtual environments and have read more documentation/articles than I can count. Some advise from those who "Do" will be greatly appreciated.