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 |
|
Rita Bhatnagar
Posting Yak Master
172 Posts |
 Posted - 2002-03-13 : 12:33:27
|
| I am not sure do we need to restrict the size of tempdb. How about for the other databases too.If we do what size should we allocate? Is it right that when we start sql server the old file got deleted and new tempdb generated? How much should be the frequency of rebooting the sql server?Last time we had problem with tempdb because we didn't have enough space on the disk.We made space on the drive and the problem was solved.Thanks for any input. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-13 : 13:08:34
|
| You do not NEED to restrict the growth of tempdb. If you are short on free disk space, you might do that.Tempdb should usually be 20-25% of your largest database. Tempdb gets recreated every time SQL server is restarted.You should never have to reboot sql unless there is a problem which requires a rebot.-Chad |
 |
|
|
|
|
|
Size of tempdb