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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 TempDB NDF files not growing proportionately.

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...

Thanks
Shishir Khandekar

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-07-31 : 17:57:56
Are they close in size? Are the file growth settings exactly the same size and were they exactly the same size when the service started?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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 regards
Shishir
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-08-02 : 12:28:29
I would ensure that you are on the latest service pack and cumulative hotfix. What does SELECT @@VERSION show?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-08-07 : 12:53:14
I would open a support case with Microsoft as this sounds like a bug.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-08-08 : 12:34:42
quote:
Originally posted by srimami

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.



It makes a huge difference for tempdb.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -