I have a question about the tempdb files and hyperthreading. Here are the sw/hw specs.
Server 2008 SP2 Standard X64 SQL 2005 Standard Sp3 x64 Dual Quad Core Xeon's E5540's (HT enabled) 12 GB Ram
My first question is how many tempdb files should I create? The guides say 16, but I've read that SQL Standard will only support 4 physical CPU's. How does sql distinguish between what is physcial / logical or cores versus sockets?
If I can get this question answered, there may be others, so first things first I suppose.
Thanks to anyone who can help.