March 30, 2009 at 10:38 am
some of my tables returned negative KB to the UNUSED column. what does that mean? Thanks
March 30, 2009 at 12:04 pm
how up to date are your statistics ?
(sp_updatestats / dbcc updateusage(0) with count_rows)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 30, 2009 at 12:42 pm
You could run DBCC UPDATEUSAGE. It's possible the allocation information is messed up because of dropped objects, large scale data changes, etc.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 30, 2009 at 1:24 pm
after dropping any index, sometimes the sys table will not update the correct info. use either DBCC UPDATEUSAGE or sp_spaceused , @updateusage = 'true' command.
March 30, 2009 at 3:36 pm
thanks guys.
after I ran dbcc updateusage, the msg said something like:
USED pages: Changed from (1444) to (968) pages.
RSVD pages: Changed from (1165) to (989) pages.
all positive unused KB now.
March 30, 2009 at 6:10 pm
Excellent. Thanks for letting us know it worked.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply