number of tempdb files?

On a 4 dual core, hyper threading server, how many tempdb files I should
configure in order to reduce schema lock contention? 8, or 16? I see 16
processors on the Task Manager. According to some articles dual-core CPU is
considered to be two CPUs. What about hyper-threading?
Thanks,
Lijun1) Consider (and test) turning off hyperthreading.
2) I would go with either 4 or 8 files for your tempdb, one per each true
cpu or one per core. I have seen guidance for one per cpu, but don't know
how the shared cache would really play out with dual core. Gut feeling is 4
would be best.
TheSQLGuru
President
Indicium Resources, Inc.
"Lijun Zhang" <sonyzhang00@.yahoo.com> wrote in message
news:u5ijH7phHHA.4904@.TK2MSFTNGP05.phx.gbl...
> On a 4 dual core, hyper threading server, how many tempdb files I should
> configure in order to reduce schema lock contention? 8, or 16? I see 16
> processors on the Task Manager. According to some articles dual-core CPU
> is
> considered to be two CPUs. What about hyper-threading?
> Thanks,
> Lijun
>