SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How Many TempDB Files Can be added to SQL Server 2008 with 32 CPU's


How Many TempDB Files Can be added to SQL Server 2008 with 32 CPU's

Author
Message
sundeep.maddi
sundeep.maddi
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 333
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.
Roy Ernest
Roy Ernest
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3760 Visits: 6869
It all depends on how your tempDB is being used. One thing to keep in mind is that the size of each of the tempDB files should be the same.
There are also lots of blogs telling you that having multiple tempDB files is not going to help performance. So this is a very open ended question.
Just my 2 cents

-Roy
Henry Treftz
Henry Treftz
SSC Veteran
SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)

Group: General Forum Members
Points: 297 Visits: 365
Some feel it is a happy medium to go with a number of tempdb files to match the number of processor chips not cores...
Mohan Kumar
Mohan  Kumar
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1537 Visits: 596
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.

--www.sqlvillage.com
vidhya sagar
vidhya sagar
Say Hey Kid
Say Hey Kid (710 reputation)Say Hey Kid (710 reputation)Say Hey Kid (710 reputation)Say Hey Kid (710 reputation)Say Hey Kid (710 reputation)Say Hey Kid (710 reputation)Say Hey Kid (710 reputation)Say Hey Kid (710 reputation)

Group: General Forum Members
Points: 710 Visits: 620
Request you to read the article http://sqlskills.com/blogs/paul/post/Search-Engine-QA-12-Should-you-create-multiple-files-for-a-user-DB-on-a-multi-core-box.aspx by Paul Randal.. Number of files actually depends on how you are going to utilize your tempdb.

Regards..Vidhya Sagar
SQL-Articles
jeff.mason
jeff.mason
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1469 Visits: 2137
And just as an aside keep in mind also that SQL 2008 R2 is only going to support 32 CPUs in the Datacenter Edition; if you get R2 Enterprise your max number of CPUs is 8.
sundeep.maddi
sundeep.maddi
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 333
Thanks for the valued suggestions, i am still looking into the different articles on number of tempdb files.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search