tempdb auto grow changes back to growth by 1 MB

Question

tempdb auto grow changes back to growth by 1 MB

Wayne-153714

Hall of Fame

Points: 3536
More actions
June 9, 2005 at 3:37 am

#186227

We have created tempdb with multiple files to improve performance. We set the files to grow by 10 percent. However, When we select Options again, the setting has reverted to file growth by 1 MB. Can anyone advise?
When in doubt - test, test, test!
Wayne

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Carl Federl One Orange Chip Points: 25384 More actions · Answer 1

This is a bug within SQL Server.

Microsoft can tell you how to fix this problem which is to update the sysfiles table to change the file growth from KB to a percentage.

You will need to restart SQL Server for the change to have an effect.

SQL = Scarcely Qualifies as a Language

Wayne-153714 Hall of Fame Points: 3536 More actions · Answer 2

Can you tell me how to make the change? I notice there is a column called status that seems to have an impact, but we are not sure what to change it to...

When in doubt - test, test, test!

Wayne

Wayne-153714 Hall of Fame Points: 3536 More actions · Answer 3

Not to worry, guys. I found the solution on

http://support.microsoft.com/default.aspx?scid=kb;en-

us;816939

(I should have read Carl's posting better.)

Regards,

Wayne

When in doubt - test, test, test!

Wayne

shahgols SSCrazy Eights Points: 9874 More actions · Answer 4

I had the same problem once and changed from 10% to 20% and it did not revert back.