question

Bugmesh avatar image
Bugmesh asked

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
servermaxdopvmhyperthreading
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
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'.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
+1. You also find some vendors tell you the best practice in terms of MAXDOP. MS CRM and Sharepoint are a perfect example.
1 Like 1 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
@sp-lock yup. Both those are recommended to have MAXDOP of 1, which will kill your server for any larger queries. Plus those systems will get you to use their own maintenance routines, rather than the standard ones. My advice for those two systems is to keep them on their own separate boxes, away from anything else. But we're getting away from the main topic...
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.