|
|
Posted by Erland Sommarskog on 12/29/07 09:53
Neil (nospam@nospam.net) writes:
> So this gets back to my original question. If there is about 1 GB of
> data in the db; and the database is showing 2.5 GB of data; then where's
> that other 1.5 GB of data coming from? Fragmentation seems to have been
> reduced greatly. So what is that other 1.5 GB that is being reported?
> This is very strange.
I'm afraid that by now I have exhausted all ideas. With the drastic
reduction of CustomerMerges, one would expect to see a big increase in
unallocated space. 226661 pages is 1.8 GB. I suspect that the number
226661 is bogus somehow.
The only thing I can suggest is that you create a new database from scripts,
and the load it with data from the current database. It may not be worth
the hassle though.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|