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
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 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
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20066 Visits: 6910
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
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2207 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
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3639 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
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4758 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
SSCertifiable
SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)

Group: General Forum Members
Points: 5139 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
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 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