dbTalk Databases Forums  

Tempdb autogrow set to 1MB

microsoft.public.sqlserver.server microsoft.public.sqlserver.server


Discuss Tempdb autogrow set to 1MB in the microsoft.public.sqlserver.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
=?Utf-8?B?amFzb243NjU1?=
 
Posts: n/a

Default Tempdb autogrow set to 1MB - 07-25-2007 , 08:50 AM






Let's say I go in and set the autogrow for the tempdb and templog to 100MB
(for example).

What could cause it to reset itself to autogrow by 1 MB? I know for a fact
that it's happened after, because or caused the "Autogrow of file 'templog'
in database 'tempdb' cancelled or timed out after 0".

We increased the size of both last week and that seemed to help until
something goes wrong...so I'm hoping someone has heard of why it would reset
itself to autogrow by 1MB even though I've changed it. What can I do to
prevent this in the future?

Reply With Quote
  #2  
Old   
Maurice De Vidts
 
Posts: n/a

Default Re: Tempdb autogrow set to 1MB - 09-14-2011 , 12:07 AM






You need to modify the autogrow in the Model database. Modifying tempDB only has a short lasting impact as tempdb is recreated from Model every time you restart the SQL Server service.



Quote:
On Wednesday, July 25, 2007 9:50 AM jason765 wrote:

Let's say I go in and set the autogrow for the tempdb and templog to 100MB
(for example).

What could cause it to reset itself to autogrow by 1 MB? I know for a fact
that it's happened after, because or caused the "Autogrow of file 'templog'
in database 'tempdb' cancelled or timed out after 0".

We increased the size of both last week and that seemed to help until
something goes wrong...so I'm hoping someone has heard of why it would reset
itself to autogrow by 1MB even though I've changed it. What can I do to
prevent this in the future?

Reply With Quote
  #3  
Old   
Maurice De Vidts
 
Posts: n/a

Default Re: Tempdb autogrow set to 1MB - 09-14-2011 , 12:08 AM



You need to modify the autogrow in the Model database. Modifying tempDB only has a short lasting impact as tempdb is recreated from Model every time you restart the SQL Server service.



Quote:
On Wednesday, July 25, 2007 9:50 AM jason765 wrote:

Let's say I go in and set the autogrow for the tempdb and templog to 100MB
(for example).

What could cause it to reset itself to autogrow by 1 MB? I know for a fact
that it's happened after, because or caused the "Autogrow of file 'templog'
in database 'tempdb' cancelled or timed out after 0".

We increased the size of both last week and that seemed to help until
something goes wrong...so I'm hoping someone has heard of why it would reset
itself to autogrow by 1MB even though I've changed it. What can I do to
prevent this in the future?

Quote:
On Wednesday, September 14, 2011 1:07 AM Maurice De Vidts wrote:

You need to modify the autogrow in the Model database. Modifying tempDB only has a short lasting impact as tempdb is recreated from Model every time you restart the SQL Server service.

Quote:
On Wednesday, September 14, 2011 1:07 AM Maurice De Vidts wrote:

You need to modify the autogrow in the Model database. Modifying tempDB only has a short lasting impact as tempdb is recreated from Model every time you restart the SQL Server service.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.