I need to find out what the concensus is on virtualizing SQL server.
I know that VMWare reports the more processors that are utilized, the more the performance degrades vs the same server in a dedicated physical environment.
With that in mind, I currently am of the opinion that Virtualized SQL instances are good for the following uses:
1.) Isolated 3rd party databases which require SA privledges that cannot be accomodated on consolidated instances due to security issues.
2.) Lightweight applications which don't require more than 2 dedicated processors on their accompanyment databases.
3.) Instances that don't require SQL clustering or HA.
Also, I don't beleive I would ever attempt to setup a clustered/HA type of environment with virutal machines.
Does anyone have anything to add? Am I correct in my assumptions?