|
Home > Archive > MS SQL Server > April 2006 > sp_spaceused on 2005
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sp_spaceused on 2005
|
|
|
| I executed sp_spaceused against every table in my database. There were two
tables out of 30 over 1 MB -- both were under 10 MB. However, when I right
click on the database in Management Studio, choose properties, and then view
the "Size" of 165 MB and "Space Available" of 4 MB, I'm confused. How are
my 30 tables (plus various other light weight procedures, system tables,
etc) possibly consuming 165 MB of Space?
Suggestions? Thanks in advance.
Mark
| |
| Edgardo Valdez, MCSD, MCDBA 2006-04-07, 8:23 pm |
| did you tried the option @updateusage = N'TRUE'?
exec sp_spaceused @updateusage = N'TRUE'
or run DBCC UPDATEUSAGE
"Mark" wrote:
> I executed sp_spaceused against every table in my database. There were two
> tables out of 30 over 1 MB -- both were under 10 MB. However, when I right
> click on the database in Management Studio, choose properties, and then view
> the "Size" of 165 MB and "Space Available" of 4 MB, I'm confused. How are
> my 30 tables (plus various other light weight procedures, system tables,
> etc) possibly consuming 165 MB of Space?
>
> Suggestions? Thanks in advance.
>
> Mark
>
>
>
| |
| Andrew J. Kelly 2006-04-07, 8:23 pm |
| use the option to update the usage or run DBCC UPDATEUSAGE and try again.
--
Andrew J. Kelly SQL MVP
"Mark" <markfield88@nospam.nospam> wrote in message
news:ejALXjoWGHA.1564@TK2MSFTNGP03.phx.gbl...
>I executed sp_spaceused against every table in my database. There were two
>tables out of 30 over 1 MB -- both were under 10 MB. However, when I right
>click on the database in Management Studio, choose properties, and then
>view the "Size" of 165 MB and "Space Available" of 4 MB, I'm confused. How
>are my 30 tables (plus various other light weight procedures, system
>tables, etc) possibly consuming 165 MB of Space?
>
> Suggestions? Thanks in advance.
>
> Mark
>
| |
| Tibor Karaszi 2006-04-08, 7:23 am |
| Lest us know if DBCC UPDATEUSAGE changes this. sp_spaceused draw the information from the system
tables, and these are supposed to be accurate in 2005. Also, let us know if you upgraded the
database from an earlier version.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"Mark" <markfield88@nospam.nospam> wrote in message news:ejALXjoWGHA.1564@TK2MSFTNGP03.phx.gbl...
>I executed sp_spaceused against every table in my database. There were two tables out of 30 over 1
>MB -- both were under 10 MB. However, when I right click on the database in Management Studio,
>choose properties, and then view the "Size" of 165 MB and "Space Available" of 4 MB, I'm confused.
>How are my 30 tables (plus various other light weight procedures, system tables, etc) possibly
>consuming 165 MB of Space?
>
> Suggestions? Thanks in advance.
>
> Mark
>
|
|
|
|
|