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

Go with one file per core - 8, in your case. Also, set the maximum degree
of parallelism to 8.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Lijun Zhang" <sonyzhang00 (AT) yahoo (DOT) com> wrote

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

Thanks!

"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote

I agree with Tom. After setting the DOP monitor the database performance
closely.

Thanks
Hari

"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote