SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Taskpad shows 0 space in DB


Taskpad shows 0 space in DB

Author
Message
Gareth Bowen
Gareth Bowen
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 6
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?



Rodrigo Acosta
Rodrigo Acosta
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2567 Visits: 22
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.



Green Armchair
Green Armchair
Old Hand
Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)

Group: General Forum Members
Points: 399 Visits: 459
Hi

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

use <yourdb>
go
sp_spaceused @updateusage = 'TRUE'



Frank Kalis
Frank Kalis
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10683 Visits: 289
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/
e_h2324
e_h2324
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 1
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.



iadams
iadams
SSC-Enthusiastic
SSC-Enthusiastic (134 reputation)SSC-Enthusiastic (134 reputation)SSC-Enthusiastic (134 reputation)SSC-Enthusiastic (134 reputation)SSC-Enthusiastic (134 reputation)SSC-Enthusiastic (134 reputation)SSC-Enthusiastic (134 reputation)SSC-Enthusiastic (134 reputation)

Group: General Forum Members
Points: 134 Visits: 1
I have the same problem.

This just worked for me...
Right-Click over the database and refresh.

-Isaiah


-Isaiah
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search