But hyper threading doesn't really double the performance of the CPU, I understood it's a marginal improvement. It seems odd to double the cost of the license if hyper threading is switched on.
I presume a database must be memory intensive.
Mine is video encoding using FFMPEG (where I run more program threads than FFMPEG decides is optimal in order to make sure no cpu thread is idle).
I get at most 15% over hyperthreading off, and often about 5-10% less than hyperthreading off (For the whole process, beginning to end).
On real cores, it is close to being linear in the number of cores (not quite, but it is close).
For decades now we've had to suffer these weird internet arguments about whether hyperthreading is "real", as if there was a naturally-occuring correct number of frontends on a CPU. If someone wants to put more instruction decoders on their CPU there is no rational argument that is "wrong".