SQL Server Performance Forum – Threads Archive
MAXDOP and HyperthreadingI have a PE 6600 with 4 CPU and Hyperthreading. I’d like to know how to decide which 4 cpu should be selected when configuring the SQL server through EM in order to select the 4 physical ones. Andrea
unless you have alot of resources to validate each individual query, i would turn off HT
I would also review the following http://support.microsoft.com/default.aspx?scid=kb;en-us;329204 http://support.microsoft.com/default.aspx?scid=kb;en-us;322385
Well, I’m running SQL 2000 SP 4 on Win 2003 server so I think maybe Hyperthreading is not necessarily to be discarded. After turning processors 4,5,6,7 off and setting the max CPU used for parallel queries the performance on large jobs has decreased a bit and I couldn’t prove that the performance of small queries has actually gotten better.
So I’m thinking of re-enabling all the CPU and use perhaps 7 out of 8 CPU for parallel execution.
Also, even after reading the articles mentioned above, I couldn’t figure out how to enable the 4 physical processors as opposed to the logical ones so in doubt, I think it’ll be best to turn them all on again.
May check thishttp://www.windowsitpro.com/SQLServer/Article/ArticleID/38758/38758.html link. HTH Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.