I have been dealing with some Hyperthreading questions latley regarding their Pro's and Con's. I currently have HT turned on for our 4-Way SQL Servers but am not convinced that it's the best way to go. This coupled with our Parallelism configurations (Defaut) might be contributing to some CPU thrashing that we are seeing.
For instance, when I run a sp_who2, I notice that some threads of a spid are waiting on the infamous CXPACKET waittype. This is telling me that while the leading thread is still running, these are just waiting for it to finish. Probably not getting the best possible performance.
I will test with these off during Q1 of next year and post my results. Anyone else have any comments regarding this?
Wednesday, November 30, 2005
Subscribe to:
Posts (Atom)