| Author |
Topic |
|
shishirkhandekar
Starting Member
23 Posts |
 Posted - 2013-07-31 : 16:51:45
|
| Hello,My question - Under what circumstances will the TempDB data files not grow proportionately?Here's the background...I have read and also tested using test code that when I have multiple TempDB data files, these files grow using a proportionate fill algorithm. Writing sample code I have also tested this and have seen it grow all the files together.We have an application in production where we are using multiple files but under some very heavy load, they don't grow proportionately.Appreciate any help on this...ThanksShishir Khandekar |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
shishirkhandekar
Starting Member
23 Posts |
Posted - 2013-08-02 : 08:20:54
|
| Hi Tara,Yes, we resized them to be the same size and the same growth increment. The growth was proportional for quite some time, but then when a big client (lots of data) was being processed, some files grew at a different rate than the others. 10 file grew equally but the other 2 did not.Thank you and regardsShishir |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
shishirkhandekar
Starting Member
23 Posts |
Posted - 2013-08-07 : 11:33:44
|
| This one is SQL Server 2008 R2 SP2 (10.50.4000). It's just this application that shows this kind of disproportionate growth, not some of the other applications. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-08-08 : 04:54:25
|
| Just to understand bit more, what difference would it make if it grows unequally. Anyways, we need to reset the tempdb growth eventually at one point.Thanks,Sri. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
TempDB NDF files not growing proportionately.