November 1, 2010 at 11:02 am
I have a SS_2000 user database that is approx 9 GB total size.
sp_database reports 9415680.
The recovery model is simple and there appears to be no non-shrunk log file.
There are numerous tables, but one in particular was larger than most.
Sp_spaceused for the intereted table reports back:
_table48960792 12046856 KB11957384 KB89456 KB16 KB
So 12046856KB is about 11 GB ? Or am I way off the mark ?
Sanity check time, please !
Thanks, Rick
November 1, 2010 at 11:35 am
Hi Rick,
I've seen some issues with incorrect space usage reporting in SQL Server 2000 (which you say you are using).
You might want to use the updateusage argument with sp_spaceused, or run DBCC UPDATEUSAGE to ensure that the correct current values are returned.
Steve
November 1, 2010 at 11:40 am
This should help
http://www.sqlservercentral.com/scripts/T-SQL+Aids/31774/
sp_spaceused can be very incorrect in SQL 2000
November 1, 2010 at 5:59 pm
Thank you for the responses, and advise, which was on-target !!
After executing "sp_spaceused @updateusage = 'TRUE'" on the target db, that returned:
-- _db9195.00 MB1989.15 MB
-- reserved = 7290728 KBdata=7222704 KBindex=66008 KBunused=2016 KB
After re-run "sp_spacedused _table", I now get:
-- _table 48960792 7105432 KB7040608 KB64192 KB632 KB
Looks more like I'd expect it to be.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply