colin Leversuch-Roberts (1/21/2009)
much as I dislike VMs I have never encountered turning off parallelism, that could be a serious hit and I'm pretty sure this is untrue. I guess some vms may be able to allocate virtual cpus or may leave HT turned on, in which case this is not the way to configure for sql server. In all the VMs I've used cores are allocated to each vm.
If you allocate cores to each VM directly, this isn't a problem, but then if you do a vMotion of the server, those settings don't follow the server. Even then, you have to manage this for all of your VM's on the host, or you still can have context switching issues between VM's. In our environment, this isn't something the server team is going to do consistently.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]