sundeep.maddi (8/17/2010)
Our company is planning to upgrade the present Cluster to an advanced hardware with SQL 2008 Cluster (A/P), as a DBA i have to confiure and install and mange the SQL Box. For the better performance company is plannig to buy 32 Core Procssor Box, is it idle to add 32 tempdb files as SQL Server performance stand point. Adding too many tempdb files can reduce performance and too much management as well, so what is best configuration for this Box.
Generally speaking, You should add number of files equal to physical processor you have on your server? My recommendation will be to start with 8 files and make sure every file has same size defined with no growth. So analyze your tempdb load before you decide about setting tempdb data file size.
[font="Verdana"]--www.sqlvillage.com[/size][/font]