it says, "Best practices call for tempdb to have one datafile per processor (core) and all to be of the same initial size and growth."
We are setting up a new machine to run SS 2008 R2 x64 on Windows Server 2008 x64 Standard. The machine has 24 CPU cores and 24GB of RAM. Should I really allocate 24 datafiles in my tempdb? This seems like overkill, especially since the machine is over-powered for the application and databases it is supporting. We'll likely have up to 12 concurrent users.
Which views, etc. would I monitor to decide if more datafiles would be helpful?
Advice appreciated. Thank you.