I'm trying to determine how many tempdb datafiles for an instance of SQL Server 2005. I have a server with 1 quad core cpu that is hyper-threaded (task mgr shows 8 cpu slices). Now, when Microsoft recommends 1 tempdb datafile for each core
are they recommending 4 or 8 datafiles?
View Complete Post