[dba-SQLServer] tempdb for JC

jwcolby jwcolby at colbyconsulting.com
Tue Jun 22 08:18:41 CDT 2010


Interesting!

John W. Colby
www.ColbyConsulting.com


Michael Maddison wrote:
> 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
> 
>  
> 
>  
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 



More information about the dba-SQLServer mailing list