January 25, 2011 at 8:20 am
Hello,
In http://www.sqlservercentral.com/articles/SQL+Server/70505/
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.
-T
January 25, 2011 at 8:28 am
Tim L-309246 (1/25/2011)
In http://www.sqlservercentral.com/articles/SQL+Server/70505/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."
Not necessarily.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply