VM ESX hosts have hyperthreaded cores enabled on database server.
I have been looking into the wait times on our database servers and was curious about how/if the ESX hosts that support our database could be causing some issues with MAXDOP currently set to '0'. I know in a physical server environment you would probably want to have hyperthreading turned off. Is it the same with a Virual Machine? Should the ESX hosts supporting the VM have hyperthreading turned off? I would appreciate any assistance provided Thank You
This isn't going to answer your specific VM question, but I just wanted to challenge your view about hyperthreading on physical servers. It used to be the case that for 'older' processors, it was recommended that HT be turned off. However since the introduction of the Nehalem processors in 2010, it's no longer such a broad sweep of advice. OLTP benefits more than OLAP/datawarehousing, but as ever, 'it depends' and 'your mileage may vary'.