Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
duhaas
Constraint Violating Yak Guru
310 Posts |
 Posted - 2007-02-20 : 11:50:22
|
| How do determine the initial tempdb size? On reboot as i understand it tempdb gets cleared, how do I dictact what the size of tempdb will be on reboot? |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-02-20 : 17:52:39
|
| Just go and set the size of the tempdb database file like you would for any other database - through ALTER DATABASE in T-SQL, or Database Properties in Enterprise Manager. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-20 : 17:57:19
|
| Yes tempdb gets rebuilt each time the service is started, like during startup after a reboot. The model database is used to build tempdb, so you dictate the size via the model database.Tara Kizer |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-02-20 : 18:07:11
|
| But if you change the size of the database file/s then you can make the minimum size larger than model. It will not go back to the size of model if you change the size of the database file/s. It will always go back down to the size you specify for the database file/s when you restart the server, but it will not go below that. |
|
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2007-02-20 : 22:55:41
|
quote:
Originally posted by tkizer
Yes tempdb gets rebuilt each time the service is started, like during startup after a reboot. The model database is used to build tempdb, so you dictate the size via the model database.Tara Kizer
I don't believe that's true. You don't change the size of the MODEL to do this. You set the size of TempDB as you would any other database....--Jeff Moden |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-20 : 23:07:39
|
| Well it's true as long as you've never changed the tempdb size. I've never played with it though as I've always just set the size to what we know it needs.Tara Kizer |
|
|
|
|
|
|
Tempdb Sizing