Post reply

negative free space in tempdb database

  • April 4, 2007 at 4:24 pm

    #119280

    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

  • April 4, 2007 at 4:35 pm

    #698671

    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