July 30, 2002 at 8:10 am
Tempdb is set to autogrow and is growing consistently. There do not seem to be any connections that have long running queries. SQL7 production environment, mostly OLTP but not terribly heavy load. Had to reboot to reinitialize tempdb once already, thought maybe a runaway process was out there, but now it is growing again. Any suggestions as to what I might look for?
July 30, 2002 at 11:19 am
Depends on how you're utilizing tempdb. Unless its way beyond the size of your db's and you're short on space, I'd let it grow until it stablizes. It will.
Andy
July 31, 2002 at 9:01 pm
Solart is right - make sure your truncate on checkpoint is switched on so that it empties the tempdb database.
I've had similar issues with my tempdb database being large - even though it's mostly empty. Remember, tempdb will be utilised when the server needs space to perform calculations that it can't do in memory. So check your indexes and/or stored procs that handle large amounts of data. If no index is utilised for a sort, SQL allocates to tempdb and attempts to sort from within there.
August 1, 2002 at 5:23 am
How large is the database? If you let the tempdb default it will start around 2MB I believe. The general rule is 25% of the database size. I agree with Andy... let it grow until it stabilizes... then give it a little more room and tear the knob off...
adjust over time as required.
Ed Thornton
itsmeagain
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply