Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
 Posted - 2009-07-13 : 12:36:38
|
| The usual rule is that the number of TempDB data files is set to the number of schedulers (virtual CPUs). I have run across an installation where the there are eight schedulers but twelve data files. I was going to remove the extra four files but i thought that I'd check to see if anyone has a rationale that might justify the additional files.Many thanks.=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-07-13 : 15:31:47
|
| Future cpu upgrade? or If its not broke dont fit it?or Default installed make DR easier?or Make use of a large number of Storage Devices? |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-07-13 : 16:26:37
|
| I doubt that the extra TempDb files help performance.On the other hand, I doubt that deleteing the extra files will help performance either.CODO ERGO SUM |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2009-07-13 : 16:47:34
|
| Based on that, I doubt that I am going to do anything with these extra file.Many thanks.=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-07-14 : 05:38:59
|
quote:
Originally posted by Michael Valentine Jones
I doubt that the extra TempDb files help performance.On the other hand, I doubt that deleteing the extra files will help performance either.CODO ERGO SUM
I agree with you...there was a performance issue in one of our application...one of my colleague suggested to increase the no. of tempdb datafiles to increase tempdb performance....they tried it on test server with out any increase in performance...later i suggested to either move tempdb to different location or add files to different hard disk.... |
|
|
|
|
|
|
TempDB files - More than # of CPUs/Schedulers