December 29, 2005 at 2:54 am
Hi All,
I have weekly maintenance job which consists of DBCC checks and reindexing steps.Often these jobs will fail due to insufficient space in tempdb as the database is not set to autogrow.Is there a means to check the appropriate size of tempdb which will be sufficient for the maintainence plan to run.
Cheers 🙂
December 29, 2005 at 3:08 am
I start with the assumption that I need a TEMPDB three times the size of my largest table.
If I have to do a large sort or reindex TEMPDB grows like a weed.
December 29, 2005 at 3:39 am
Well, thats the practice you follow.Is there a KB article or doc to just.
December 30, 2005 at 12:38 pm
Rough estimate is 25% of your big database size. You can estimate the dbcc checkdb tempdb requirement by running DBCC CHECKDB WITH ESTIMATEONLY. Temdb growth depends on how many worktables/objects created during that time period. It is better to increase the no. of tempdb data files to equal the no. of processors with each file size equal (http://support.microsoft.com/kb/328551)
January 3, 2006 at 10:41 am
Just a question, Do you have a reason for not setting your tempdb to autogrow? If you don't have the space I can understand, but if you do have enough space, let tempdb do it's thing without restrictions.
Steve
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply