Something strange is happening to our SQL Server DB (2000). The
tempdb transaction log file continues to grow (quite slowly) for no
apparent reason. We have it in simple mode, and I have tried a manual
checkpoint command and manual shrink (of the log file only). There
are no unusual SQL's (large or small) going on. A "heavy hitter" would
make it grow fast, not 10 MB every 30 minutes or so. This server has
been in production for over a year with no similar issues to this.
Anyone encounter a similar situation? This started (as far as we can
tell) sometime yesterday. It is growing about 200 MB a day, and is up
to 600 MB now, with all but 8 MB "used". For now we added space, but
of course that is not a long term solution. The two "data" files
(each had a 200 MB initial allocation) have never gone much above 100
MB each used (they are each about 100 MB now and have been that way
for several days, but have shrank and grown). There are about 30
small to medium sized "regular" databases on this instance.
Any help would be appreciated, especially if there is a way we can fix
this without bouncing the engine (I know, wishful thinking...). The OS
is Win 2000, SP3. SQL Server is at 2000, SP 3a.
THANKS IN ADVANCE!