First of all, my sql2008 R2 instance is running normal. The SSMS Database Properties screen shows the temp db size is 1M with auto growth. On the shrink file screen, it shows that the log available space is 0.5M and free space is -239M (Note the Minus sign).
The file system shows the log file size at 512M.
DBCC Perf(logspace) shows that the log file size is 512M and available space at 46%, which is reasonable to me.
It looks that the instance's internal stats is off. Anyone ran into this before?
Any advice before I try restarting the SQL service?
Thanks.