There are several questions asking if disabling hyperthreading will improve performance (e.g. like this). The answer (as it is to all performance questions) is of course "profile it on your workload".
As running experiments in a production environment is a poor idea (who wants to see reduced performance from an experiment in production!) and it isn't always feasible to set up a realistic development environment, I was wondering what measurements are available to determine if hyperthreading might be hurting performance (such that we only run an experiment that is likely to succeed!).
- This isn't an SQL specific question, I'm not looking for SQL statistics but rather performance counters from the operating system
- The source code isn't available so no changes can be made there to monitor performance.