[dba-SQLServer] tempdb for JC

Hi John,

 

Came across a discussion on tempdb that may be useful for your upgrade.
I've never consider multiple files for tempdb, never needed to....

 

Cheers

 

Michael

 

'Create as many files as needed to maximize disk bandwidth. Using
multiple files reduces tempdb storage contention and yields
significantly better scalability. However, do not create too many files
because this can reduce performance and increase management overhead. As
a general guideline, create one data file for each CPU on the server
(accounting for any affinity mask
<http://technet.microsoft.com/en-us/library/ms187104.aspx>  settings)
and then adjust the number of files up or down as necessary. Note that a
dual-core CPU is considered to be two CPUs.'

 

http://technet.microsoft.com/en-us/library/ms175527.aspx