SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 TempDB NDF files not growing proportionately.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

shishirkhandekar
Starting Member

23 Posts

Posted - 07/31/2013 :  16:51:45  Show Profile  Reply with Quote
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

USA
36845 Posts

Posted - 07/31/2013 :  17:57:56  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 08/02/2013 :  08:20:54  Show Profile  Reply with Quote
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

USA
36845 Posts

Posted - 08/02/2013 :  12:28:29  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 08/07/2013 :  11:33:44  Show Profile  Reply with Quote
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

USA
36845 Posts

Posted - 08/07/2013 :  12:53:14  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 08/08/2013 :  04:54:25  Show Profile  Reply with Quote
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

USA
36845 Posts

Posted - 08/08/2013 :  12:34:42  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000