In high-load but I/O bound tasks Hyperthreading (Intel market speak for SMT) is magic. If something is compute bound, you are correct and the benefit is often slim, but typically not for application or database servers.