SQL Server - sp_spaceused concern

Asked By Niti

07-Mar-07 10:59 AM

I used sp_spaceused on one of the table and here is the output.

name,rows,reserved,data,index_size,unused
CreditCard_Protect ,8041839,674793648 KB,665420648 KB,5219808 KB,4153192 KB

In the data column, I see 665420648 KB which turns out to be > 600 GB which
is not true. Actual size of the table is much less than 600 GB or am I
missing something here? Table has up to date Indexes.

-Nitin

07-Mar-07 11:07 AM

Try:

dbcc updateusage (0, 'CreditCard_Protect')

and retry.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON   Canada
.
I used sp_spaceused on one of the table and here is the output.

name,rows,reserved,data,index_size,unused
CreditCard_Protect ,8041839,674793648 KB,665420648 KB,5219808 KB,4153192 KB

In the data column, I see 665420648 KB which turns out to be > 600 GB which
is not true. Actual size of the table is much less than 600 GB or am I
missing something here? Table has up to date Indexes.

-Nitin

07-Mar-07 11:13 AM

If you think that you get incorrect results, you use the
@updateusage  parameter to make SQL Server check the space that the
table uses.  Check BOL for sp_spaceused and dbcc updateusage.

Adi

07-Mar-07 11:31 AM

Thanks.