MAXCPU cores + hyperthreading

[Former Member]

Hi all,

I have a server with 2 CPU's with 6 cores each and hyperthreading enabled.

I've read in posts and notes that it is best to set the param MAXCPU to 12 in this case. Is this correct? It's a dedicated db server.

Is the performance better when I turn off hyperthreading?

Cheers,

Jan

Edited by: Jan van Nunen on Sep 23, 2010 7:24 PM

[markus_doehr2]

> I have a server with 2 CPU's with 6 cores each and hyperthreading enabled.

> I've read in posts and notes that it is best to set the param MAXCPU to 12 in this case. Is this correct? It's a dedicated db server.

> Is the performance better when I turn off hyperthreading?

On all our systems hyperthreading is switched off and MaxCPU is set to the number of cores (not threads). We had performance issues in the past when hyperthreading was enable and the database was configured according to the number of available threads.

So I'd set your MaxCPU to 12 and "ignore" the threads.

Markus

[Former Member]

Thanks Markus for the reply.

We are going to use 7.6.06.10 on the Linux system and I thought hyperthreading would help a bit.

Cheers,

Jan

[markus_doehr2]

> We are going to use 7.6.06.10 on the Linux system and I thought hyperthreading would help a bit.

Any reason why you don't plan to use an actual build?

Markus

[Former Member]

Hi Markus,

Well, our current production systems are running 7.3 and we are going to migrate these to 7.6. I think 7.7 is maybe a too large step at the moment. We know 7.6 is around for some time and stable, so we opted for that.

Jan