I selected properties for TempDB and it shows :
Currently Allocated space : 2.00 MB Available Free space : -795.13 MB (-39756%)
templog.ldf has grown to 13.9 GB currently.
Any reasons for the above ?
asked Mar 08, 2010 at 06:04 AM in Default
Seems odd. It sounds like it's done a bunch of work, but hasn't checkpointed yet. That way, the size of the database in RAM could be larger than the database on disk. Also, having no checkpoint done would be seeing the log file grow, as it can't truncate.
One interesting thing about tempdb is that although lots of activity will still cause the log file to be written to, the temporary nature of the data should mean that it rarely needs to appear in the MDF file.
Make a connection to the tempdb database and run the command CHECKPOINT. Then have another look and see if my theories hold.
And yes, this is the kind of thing that makes me wish I had the time and money to do an MCM in SQL.
answered Mar 08, 2010 at 06:13 AM