Post reply

EM: Taskpad View explaination

  • April 23, 2007 at 3:30 am

    #68366

    Hello!

    i have a little question: in my EM i use Taskpad view to see database space used and available.

    In top part of this view, in Database section i see the actual "size" of my db and then the "space available = 0".

    In Space Allocated section i see the graphical bar and here there are some MB free on my datafile and tlog file.

    Why in the first section "space available" is 0??

    And what can i do to change and improve my db this value means a problem??

    Thanks!

  • April 23, 2007 at 8:37 am

    #701937

    Run

    DBCC UPDATEUSAGE (dbname)

    in query anaylzer. The data sometimes need to be refreshed.

     

    I want to say thou that the number can be different when there are pages allocated in the database but marked as available. The "Space Available" data will reflect it as available where the other will reflect unallocated freespace in the database. Could be wrong as I haven't used this screen much over the years.

  • May 2, 2007 at 2:28 am

    #703742

    thank Antares686 for your help.

     

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

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