Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Taskpad shows 0 space in DB Expand / Collapse
Author
Message
Posted Thursday, December 11, 2003 4:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 31, 2008 10:04 AM
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?




Post #19104
Posted Thursday, December 11, 2003 5:51 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 4:43 PM
Points: 1,581, Visits: 6
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.




Post #90844
Posted Friday, December 12, 2003 1:44 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 2:17 AM
Points: 207, Visits: 293
Hi

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

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






Post #90845
Posted Friday, December 12, 2003 2:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 1:18 AM
Points: 5,956, Visits: 285
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/
Post #90846
Posted Friday, December 12, 2003 8:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 28, 2005 8:21 AM
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.




Post #90847
Posted Friday, December 12, 2003 12:02 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 13, 2005 10:53 AM
Points: 98, Visits: 1
I have the same problem.

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

-Isaiah



-Isaiah
Post #90848
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse