Discussion Locked

tempdb

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an application running on SQL 6.5. I always seem to run out of tembdb database space. I keep on increasing it, but this becomes quite frustrating.

5 replies

by dheupel

Are you also flushing out your transaction logs? If not, do so. Without flushing your transaction logs, tempdb will continue to grow.

by tonyp_fno

Try reorganizing/resizing the table. Even if data is being removed the space stays in the table until the data is reorganized. I believe that you can set it to autogrow so that you don't have to constantly manage the database size.

This discussion is closed to new replies.