|
|
Posted by Neil on 12/29/07 18:24
OK, running sp__spaceall has yielded some interesting information. It's
showing that a single table, Descriptions_Docs, has a data size of 2 GB. So
that would certainly explain why the db was showing 2.5 GB of data. However,
when I run the
select object_name(id), reserved, used, dpages
from sysindexes
where indid in (0,1)
order by reserved desc
query, Descriptions_Docs doesn't even show up as one of the largest tables.
Here's the output from sp__spaceall:
Name Rows
ReservedKB DataKB
IndexSizeKB UnusedKB
Descriptions_Docs 66570
2410384 2038048
40 372296
And here's the output from select from sysindexes:
Table Reserved
Used dpages
Descriptions_Docs 1185
1176 1171
So this shows a usage of about 9600 KB, as opposed to about 2038100 KB. A
vast difference.
Descriptions_Docs is a table that's used for storing rich text documents in
text fields. Each row has: 1 int field (PK); 6 text fields; 3 datetime
fields; 1 smalldatetime field; and a timestamp field. The text fields
contain anywhere from zero to a couple of KB worth of data each.
In and of itself, I wouldn't be surprised that Descriptions_Docs is using
that much space. But it's the overnight jump from a db size of 1 GB to a db
size of 3 GB that perplexes me. Looking at the data for Descriptions_Docs
from right before the database ballooned in size, sp__spaceall shows that it
was only half a GB in size:
Name Rows
ReservedKB DataKB
IndexSizeKB UnusedKB
Descriptions_Docs 66489
454808 452696
1336 776
So it went from half a GB to 2 GB practically overnight, with no significant
increase in rows!
The output from select from sysindexes on the older database is:
Table Reserved
Used dpages
Descriptions_Docs 1586
1573 1406
So this shows a usage of about 13000 KB.
So, between these two databases (the earlier one a day or two before it
ballooned, and the later one being the current one, about a week later), the
number of rows stayed pretty much the same. sp__spaceall shows an increase
in usage from half a GB to 2 GB, whereas select from ssyindexes shows a
decrease in usage from about 13000 KB to about 9600 KB.
Anyone have any idea what's going on??
Thanks!
Neil
Navigation:
[Reply to this message]
|