April 18, 2003 at 11:00 am
We have a production server that is up 24/7. Right now the properties of the tempdb are set to automaticlly grow files (in megabyte chunks) and to not restrict the grwoth. I am worried that if I change these settings the server will have problems serving our databases for our website. But, the other problem is that the temdb keeps growing because we don't reboot the server very often or stop and start our sql services. Is there a better way to mange this? Thank you. Any knowlege base articles I should reference for the Boss on this to make him happy....
April 18, 2003 at 11:01 am
quote:
We have a production server that is up 24/7. Right now the properties of the tempdb are set to automaticlly grow files (in megabyte chunks) and to not restrict the grwoth. I am worried that if I change these settings the server will have problems serving our databases for our website. But, the other problem is that the temdb keeps growing because we don't reboot the server very often or stop and start our sql services. Is there a better way to mange this? Thank you. Any knowlege base articles I should reference for the Boss on this to make him happy....
April 22, 2003 at 3:32 pm
You can run dbcc shrinkdatabase(tempdb)
from QA anytime.
Robert
April 22, 2003 at 3:50 pm
Agree, can schedule it to run at 1:00 am on a Sunday or daily.
April 23, 2003 at 9:36 am
thank you
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply