SQL Server Performance Forum – Threads Archive

Negative value for index size

Hi, One of my tables are showing a negative for its index size. What does this mean? Thanks,
Raymond

Where are you seeing this? Have you tried running sp_updatestats?

Run: sp_spaceused @updateusage = ‘TRUE’ and check again.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

How often you run DBCC DBREINDEX? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Quite often on this table. Raymond

Tried as suggested by Luis?
or
DBCC UPDATEUSAGE on that table/index. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Will thy Luis’ suggestion during my maintenance window tomorrow. Will keep you guys posted. Thanks! Raymond

Hi! update usage solved it thanks! Raymond

Its better to schedule a DBCC DBREINDEX in order to update the information and performance, or DBCC UPDATEUSAGE if you want to represent the correct values. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

I did dbcc dbreindex but it showed a negative value.<br />Only after dbcc updateusage was it rectified.<br />Thanks guys! <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /><br /><br />Raymond

]]>