January 24, 2008 at 8:38 am
Can I configure the defaultsize for the tempdb on creation when SQL Server starts? As it is now I have to check if SQL Server has been stopped/started and then resize the tempdb. Ofcourse I could schedule it after each reboot, but I would prefer a defaultsize at startup.
Greetz,
Hans Brouwer
January 24, 2008 at 8:40 am
Go to the properties of the database, tempdb. Set its sizes. Next time, these sizes will become its default.
By default, the tempdb has 8 MB size.
January 24, 2008 at 8:47 am
And while you're there - you might care to change the growth factors to something more intelligent than 1MB (so you don't fragment the heck out of the disk subsystem.)
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
January 24, 2008 at 9:13 am
Set tempdb so it doesn't need to grow. Look at what the peak size appears to be, add a slight pad, and size it there.
January 24, 2008 at 1:14 pm
Tnx for answering all.
I am amazed the size I set will be 'remembered'. I would think it must be stored somewhere...
Greetz,
Hans Brouwer
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply