Post reply

Taskpad shows 0 space in DB

  • December 11, 2003 at 4:02 am

    #66172

    Hi,

    The taskpad view of a db is reporting 0MB available even though there are 2 additional data_files, each of 4GB, which are showing as unused under Space Allocated.

    The original data_file is 32GB and under Space allocated is shoing 600 MB free.

    I am running SQL Server 2000 SP3.

    Any ideas and should I be worried?

  • December 11, 2003 at 5:51 am

    #485685

    The Task Pad view starting failing in my EM after my DB was very big.

    Now my db in 300 Gb and most of the cases EM shows me an error in task pad view.

    I had to get used to use sp_spaceused.

  • December 12, 2003 at 1:44 am

    #485884

    Hi

    Taskpad view sometimes tells lies, especially if you are rebuilding indexes. You may need to run:

    use <yourdb>

    go

    sp_spaceused @updateusage = 'TRUE'

  • December 12, 2003 at 2:40 am

    #485899

    IIRC, EM uses DBCC showfilestats to show db statistics on size.

    Can you post this results?

    I guess there is nothing to worry about.

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 12, 2003 at 8:41 am

    #485967

    I often get some errors with taskpad and it often does lie. However, I do see taskpad views for over 1 Terabyte size databases that stay correct... try this: go to the actuall database in EM, right-click on it, go to view, click on detail or anything but the taskpad view. Then repeat the process and click on taskpad view. See if this updates your screen data.

  • December 12, 2003 at 12:02 pm

    #486011

    I have the same problem.

    This just worked for me...

    Right-Click over the database and refresh.

    -Isaiah


    -Isaiah

Viewing 6 posts - 1 through 5 (of 5 total)

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