May 24, 2012 at 1:31 pm
Every time I restart the MSSQLSERVER service the tempdb is reset to 60GB. I can reset it to get it manageable again but if the service is ever restarted it jumps back up to 60GB. Does anyone know how to fix this? Thanks
SQL Server 2005 Enterprise Edition sp4 (stand alone)
running on Windows 2003 R2 Enterprise Edition x64 sp2
May 24, 2012 at 1:35 pm
looks like someone has set this value based on the sizing requirement for the tempdb utilization. Reducing this value could cause a performance issue. Do you know for sure this is what is needed?
Tempdb usually starts off at 8 MB which is too small so sizing it to start off at 60 GB ( if thats the anticpated growth) is a good thing instead for autogrow in 1 MB increments
PS:- lookup alter database modify file syntax for details on how to change the initial size.
May 24, 2012 at 1:39 pm
Agreed, but this is a test server and if I set the Tempdb to 2GB it will re-size to 2GB. But if I restart the SQL Service it will go back to 60GB.
May 25, 2012 at 1:11 am
you probably have a startup proc enabled, checkout the below link for details
http://weblogs.sqlteam.com/mladenp/archive/2007/08/14/60280.aspx
May 25, 2012 at 1:47 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply