negative free space in tempdb database

  • I recently noticed that the sql server 2005 management studio is showing  negative values[eg:-533.3%] as free space in my tempdb database.This is the first time that I have seen this happen,could anyone let me know what this exactly is  and is this an issue that needs to be resolved or does this happen.Thanks

  • Enterprise Manager and Management Studio GUIs sometimes get out of 'whack' from the actual information. Try this....

    Open Query Analyzer

    Run DBCC UPDATEUSAGE('tempdb')

    When it finishes, go back to Management Studio, click on the Instance, refresh, then click on Tempdb and select properties. It should show the true values.

    -SQLBill

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply