High parallel_max_servers

43600042

sundog315 发表于 2013-3-22 11:09
对了，昨天在看一个OLAP的文档，提到了这个

OLAP Performance Tuning

你好，在么？

wolfop

Yong Huang 发表于 2013-3-23 03:19
Nehalem CPU hyperthreading is buggy and so should be disabled? I can't find such suggestion on MOS ( ...

??
I don't mean this. The real meaning is the HT is usless before Nehalem, disable it may get better performance. But begin with Nehalem, HT is useful.

Yong Huang

> HT is usless before Nehalem, disable it may get better performance. But begin with Nehalem, HT is useful.

Ah! I misread. Thank you for clarification.

sundog315

不仅仅是Intel CPU，对于Power 7芯片，我们的一个经验是开启多线程后，性能反倒有下降。不过，没有官方的说法，只是我们在做压力测试时的结果，并且，可能仅相对于当时的压力测试。

Yong Huang

> 我们的一个经验是开启多线程后，性能反倒有下降

Thanks for sharing this experience.