Advanced Micro Devices Inc (AMD)

[StocksR4Me]

Several years ago we did extensive research on the web and Microsoft's own site to determine if we should turn on HT on our IBM X235 dual Xeon servers. They are primarily used as SQL 2000 servers. The best answer we could find was - it depends.

It primarily depends on whether the application can make use of the multiple threads. For SQL 2000, we found that various queries and reports ran faster on our lightly loaded servers so we left it turned on. We also decided that we would turn it off on any heavily loaded servers since we found many examples and forums describing a fall off in performance as average cpu utilization became high.