November 26, 2003 at 7:49 am
I've got "hopefully" a simple question.
Is their some way that I can manage the tempdb database? I know the tempdb gets wiped out on a server restart, but it could weeks or months in-between our SQL Server retarts.
The reason I ask is we had a stored procedure that made the tempdb log grow from 2Mb to 92Mb everytime it was ran (which is fixed now). But it got me thinking on how big this can actually get.
I was just wondering if anyone had any suggestions on cleaning this up weekly, or if it was even worth it. As always your input is greatly appreciated.
Shane
November 26, 2003 at 4:11 pm
Why isn't the SP cleaning behind itself.. That's the normal practice..
November 26, 2003 at 4:35 pm
Usually when the SP finishes or the user connction terminates, the temp tables are all released. what you will have a pretty fragmented data file.. Unless, you have multiple users accessing tempdb at the same time, tempdb data file + log shouldn't increase in size dramatically. Even if it does, you can surely use truncate and shrink options to maintain sizes..
Hope this helps..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply